Help

[RobertM]

I want to (1) Run a query with a specific value (2) run a report from the
query (3) close the report (4) run the query again with a different value (5)
run the same reort (6) keep doing this until I've run all the reports I want.

This should be easy. Help, how do I do it with a Macro!!!

 

[DaveFromDover]

The way I would do what I think you're trying to do, doesn't involve a macro
at all except maybe a macro to open the report.

First I would create the query as a parameter query. This is done by
putting a prompt in brackets on the criteria line:

=[Enter the city]
or
Between [enter the start] and [enter the end date]

If the query is a crosstab query be sure to also enter the parameters in the
parameters dialog. This seems to be optional for other query types but its
mandatory for a crosstab query.

Then build the report based on the results of the query. Each time the
report is run you will be get an input box that asks you for the criteria.
In the case of the between example two boxes will open one after the other.

Building reports on queries is always a good idea because they are alot
easier to edit if your table design changes.

Hope this helps,
Dave