Access Macro

[Les Grigsby]

I am trying to create an Access macro. I have created a
query and a report that will print the results of the
query. When the macro runs, I want the query to be called
up, change the query (date field), same the query and run
and print the report. Any suggestions.

 

[John Vinson]

I am trying to create an Access macro. I have created a
query and a report that will print the results of the
query. When the macro runs, I want the query to be called
up, change the query (date field), same the query and run
and print the report. Any suggestions.

No macro is needed. Instead, change the Query to use a Parameter
rather than a fixed date.

For instance, if you want the report run using today's date, put

=Date()

on the criteria line instead of #10/23/2003#. If you want the user
prompted for a date put

[Enter date:]

Then you can simply open the Report directly; the user will be
prompted, and the report will use their response as the criterion.