Limiting Date Ranges in a Report

[Trakkan]

Basically, I have created a QC report to show the historical values of our products over time. The goal is to be able to show the monthly QC data for the previous 3 months, and then a summary of the yearly totals.

I had no issues creating the report to summarize the data by month. I was also able to use the category footer to sum the entire data range from the query (which was limited to the previous year) to show the yearly totals. However, I don't know how to limit the individual months that are displayed so that only the previous 3 are listed. Listing 12 individual months in the report (for every product we are including) would clutter the report to the point where it loses a great deal of its usefullness, but I'd like to retain the ability to summarize the yearly totals.

I know I can limit the months displayed the same way I limit the query to the previous year, but then I would lose the ability to summarize the yearly data. Is there a way to do both within a single report in Access?

 

[GaryPanic]

yes..
I presume you are running your report from a form
ok
in this form put two unbound fields date format ddmmyyy

from and to

now refer to qry date critia to the form
lets say the form name is formA
and the from field is call from and the to field is called to
your qry will have in the date field
Between [forms]![formA]![from] and [forms]![formA]![to]
this allows you any date range


this basical is the same qry but you ahve made the qry look for the date range

 

[GaryPanic]

ahh.
having reread your request

I think you need groupings totals with unions qry - not my strong point this
had asked a similar question on this

when you say months it is easier to say 30 -60-90 days

again you will want to point your qry to a date range on a form
so 30 back from now or 30 days back from 1st september

this I would have as a sub report
in essense you need to get the first qry right 30 days from x and this is the basis to start from - one of the proper Access guys should be able to point you inth e right direction -- I have notes on this at home - but have nto got to it - from memory it is relatively easy - but I have not done this

g