One query runs other queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have written 5 queries. Each one makes a table that the next query uses as
input. I am only interested in the results of the last query. Is there a way
to "link" all the queries so I just need to run one and the others are
executed in order?
 
The easiest way would be via a button on a form. The
code to run the queries is straight forward:-
Docmd.setwarnings false '**Turns warning messages off
Docmd.OpenQuery "Query1"
Docmd.OpenQuery "Query2"
Docmd.OpenQuery "Query3"
Docmd.OpenQuery "Query4"
Docmd.OpenQuery "Query5"
Docmd.setwarnings true '**Turns warning messages on
 
It is rarely necessary to do this. You can use a query as a table in most
cases.

Of course, your case may be the exception to the rule. Can you post the SQL
statements you are using? If you do, someone might be able to help you.

Example.
Select Max(ActionDate) as MaxDate, UserID
From SomeTable

Save that as queryA
SELECT UserID, ActionDate, Cost
FROM SomeTable INNER JOIN QueryA
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combine Duplicates in Query 0
Make table query: [Enter 1] AS Test 1
SUM in a UNION query 2
Parameter Query Won't Run 0
Use In() Expression as Query criteria with guts from Function 1
Query producing different results each time it is run 2
query several fields 5
Run Make Table Query on Union Query 2

Back
Top