Query - Based on Form Date Criteria

[mbp007]

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

 

[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?