How to run multiple queries

  • Thread starter Thread starter Pinacle
  • Start date Start date
P

Pinacle

Could someone explain or post material on how to run multiple queries at same
time using macros.
I am in need to run 12 queries in whihc one query should trigger another
query.

Thanks in advance.
 
You cannot run them at the same time.
Do you mean run them consecutively (one after another)? If so, simply list
them one after another in the macro.
If you mean one query uses another query's output as its input, you only
have to run the last query in the sequence, Access will take care of running
the queries needed by that one. E.g. if you have
Query1: select from Table...
Query2: select from Query1...
Query3: select from Query2...
you only need to run Query3.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".
 
Back
Top