What is the best way to run a report with the following date criteria:
Daily ,weekly,Monthly, Quarterly, Yearly. I realize that I can enter
an [start date] & [end date ] in a expression however the above
reports are ones that are consistently required. I would like the user
to simply select their choice.
TIA

Need a little more info -- how much data will the daily contain - one day of
data, a weeks worth, or years worth? Monthly - single set of data or 12
months of records?

You can use a form with option groups. The number selected in the option
group be used in a DateAdd function for criteria. Second option group to do
same for how much data.
Have a query per roll-up into a union query. The individual query also use
the option group number as criteria to select/not select records.

--
KARL DEWEY
Build a little - Test a little


"(E-Mail Removed)" wrote:

> What is the best way to run a report with the following date criteria:
> Daily ,weekly,Monthly, Quarterly, Yearly. I realize that I can enter
> an [start date] & [end date ] in a expression however the above
> reports are ones that are consistently required. I would like the user
> to simply select their choice.
> TIA
>
>