Query on Multiple Queries

[psycoperl]

Hi folks,
I am using MS ACCESS to query a MS EXCEL spreadsheet.

I have 6 queries on the the spreadsheet that return the same fields, I would like to know if it is possible and how to write 1 query that will combine all the UNIQUE results so that I can create a Mail Merge in MS WORD.

All the queries return

Phase, Type, Student ID, First Name, Last Name, Address, City, State, Zip Code, Test(s) Needed, TestDate, TestTime

Thanks for your assistance.

 

[SydneyGeek]

You can do that with a UNION query, which needs to be built in SQL. Do the following:

1. Open each of the 6 queries and switch to SQL view. Query1 ... Query6
2. Create a new, blank query and switch to SQL view. This will be the UNION query.
3. Copy all of the SQL from Query1 and replace the SELECT word in the UNION query. Remove the final semi-colon
In the next blank line, type UNION
4. Now, copy the SQL from Query2 and paste it below the UNION row. Remove the semi-colon, go to the nect blank line, type UNION.
Repeat step 4 for Query3 ... Query6

You should end up with
SQL from Query1
UNION
SQL from Query2
UNION
SQL from Query3
UNION
SQL from Query4
UNION
SQL from Query5
UNION
SQL from Query6

Save the query and run it.

Denis

 

[giacomo]

if the 6 queries are against the same table it's possible that you need to write your query in such a way to get all the records you need rather than distributing it out over 6 queries and then unioning them all back together in a seventh.