I need to report data for each month from an Access database. I would like to
set up the report so that I do not have to change the query each month. I
would like the business user to run the report for a specified month without
having to deal with query or with me. I have set up a query using the
STARTDATETIME field ( (DatePart("m",[StatsModuleLaunch]![StartDateTime]))=7)
to find the appropriate records . Right now, I go and change the query and
then run the report based on that query. How do I set up a prompt to change
the report ? It would be easier for business user to be able to answer a
prompt on a report vs. trying to work with queries. Also How do I
"automatically" change the Report Header so that it displays the month ie.,
Monthly Report for June 2004?