How do you run queries in Macros without opening them first?

[AshikHusein]

I am creating Macros which first run queries and then run the report based on those queries. The problem is that to run the Query it seems that you have to first open it within the macro, run it and then close it after which you run the respective report.
This causes the screen to flash with the opening and closing of queries. Is there any way to run a query without opening it??

The reason that the query has to be run before the report is because there is new data input every day into the data table.

 

[ColinEssex]

If the report is based on a query, it'll pick up the latest data when you open the report. No need to run the query first, the report does it.

Col

 

[AshikHusein]

Thank you! That clears my understanding a great deal.