Answer for:

MSFT Access - Using the Query more than once

Message 6 of 5

View entire thread
0 Votes

When you say run a query, do you mean run an action query (delete, update, append, etc.) or a select query?

If you want to compare two select queries, you can create a new query and include both queries as source queries. Make sure to join them together on the primary key. You can left or right join them to see if one query has records the other doesn't. If you use inner join, you only get the records that both queries return.