Combining multiple select queries into one select

  • Thread starter Thread starter Andrea
  • Start date Start date
A

Andrea

I am trying to combine multiple select queries into one
select query, but I am not getting the results that I
want. Any tips for this process?
 
Completely depends upon what you mean by "Combine". Do you mean that you
want to have records from all the queries show in one query? If yes, you
want a UNION query:

Selectquery1 SQL Statement

UNION ALL Selectquery2 SQL Statement

UNION ALL Selectquery3 SQL Statement


Note that there must be the same number of fields in all queries, and the
first fields must all be formatted the same, the second fields must all be
formatted the same, etc.
 

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
Merging Fields in a query 1
This has got to be an easy question? 9
Append Union Queries 2
Combine queries 2
Union Query 4
Access Query - "Duplicate Records Selected" 5
COMBINING QUERIES INTO 1 3

Back
Top