Macro Query Automation

[DaveB]

I have a parameter query that runs off a macro. I want a
second totals query that uses the results of the parameter
query to run off the same macro. How would I set this up.
Thanks.

DaveB

 

[Ken Snell]

When you say the second query uses the first query's results, do you mean
that the first query is a table in the second query? If yes, then don't call
the first query in your macro -- just call the second query. The second
query will automatically run the first query.