Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Query - Based on Form Date Criteria

Discussion in 'Information Technology' started by mbp007@gmail.com, Jul 28, 2006.

  1. mbp007@gmail.com

    mbp007@gmail.com
    Expand Collapse
    Guest

    I need to create a query which pulls the StartDate and EndDate from the
    Form. Example: when I run the query, it will ask me for StartDate
    (6/6/2006) and then EndDate (7/5/2006). What I also need is the Data
    for Previous Month too in same query.. So the data should pull from
    5/6/2006 and 7/5/2006.

    If i select the date 6/1/2006 and 6/30/2006 .. the date should get from
    5/1/2006 and 6/30/2006.

    Is there anyway I can have the field lable CurrentDate and
    PreviousDate.. so when I pull report it will have data like below:

    Query has below info: Region, Facility, Date, Counts

    What I need is like below:

    Group by Region

    MI
    1 2 3 4 5 6
    7 8 9 10 ........ 31
    HenryFord CurrentMonth 2 5
    PreviousMonth 1 3 0
    UOFM CurrentMonth 6 2
    PreviousMonth 1 6



    I need to pull the report like this...

    Please Help
     
  2. Loading...

    Similar Threads Forum Date
    Query about Jhatka Meat by Shooting in Head Sikh Sikhi Sikhism Aug 26, 2011
    Who is a sikh? A non sikh friend's query!! Sikh Sikhi Sikhism Apr 30, 2010
    General Query Hard Talk Sep 4, 2008
    Power of pauri's in Japji Sahib query Sikh Sikhi Sikhism Aug 17, 2006
    Sikhism a query Book Reviews & Editorials Aug 2, 2005

  3. KARL DEWEY

    KARL DEWEY
    Expand Collapse
    Guest

    Give an example of your data to include table and field names.

    Did I understand correctly that for any start date you want data for the
    month prior also?

    "mbp007@gmail.com" wrote:

    > I need to create a query which pulls the StartDate and EndDate from the
    > Form. Example: when I run the query, it will ask me for StartDate
    > (6/6/2006) and then EndDate (7/5/2006). What I also need is the Data
    > for Previous Month too in same query.. So the data should pull from
    > 5/6/2006 and 7/5/2006.
    >
    > If i select the date 6/1/2006 and 6/30/2006 .. the date should get from
    > 5/1/2006 and 6/30/2006.
    >
    > Is there anyway I can have the field lable CurrentDate and
    > PreviousDate.. so when I pull report it will have data like below:
    >
    > Query has below info: Region, Facility, Date, Counts
    >
    > What I need is like below:
    >
    > Group by Region
    >
    > MI
    > 1 2 3 4 5 6
    > 7 8 9 10 ........ 31
    > HenryFord CurrentMonth 2 5
    > PreviousMonth 1 3 0
    > UOFM CurrentMonth 6 2
    > PreviousMonth 1 6
    >
    >
    >
    > I need to pull the report like this...
    >
    > Please Help
    >
    >
     

Share This Page