Access Macro

  • Thread starter Thread starter Les Grigsby
  • Start date Start date
L

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.
 
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.
Click to expand...

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.
 
Back
Top