compairing figures between 2 date ranges

[wilkob]

A collegue of mine asked me to write some reports that compair sales figures between 2 date ranges.
I have a table that stores invoice no, date, customer no and the date.
I have created a form in which there entry fields for Date Range 1 (StartDate1, EndDate1) and Date Range 2 (StartDate2, End Date 2).

I created queries that filters and groups the sales figures by customer for each date range, but now I seem to be stuck as I cannot get the 2 ranges in 1 query to use for my report.
Utlimately the report should show: customer, column for date range 1 and column for date range 2.

I would really appreciate if someone could help me out here (get me over this mental hurdle

Thanks

 

[NJudson]

In your date field in the query enter into the criteria:

Between #12/1/2004# And #2/2/2005#

This will filter and only show stuff between 12/1/2004 to 2/2/2005.

**FYI, it isn't good practice to use date for a field name. There are certain reserved words that access uses that should not be used for field names and Date is one of them. You can do a search for reserved words on the forum for a better explanation of them.