"Merging" queries

[noccy]

merging multiple queries
Hello!

I have three queries with the same structure. They all have two culumns, named ID and Adress.

Can I merge theese three queries into one fourth query containing all records, and how?

noccy

 

[shenlee]

Can you tell me how to post a totally new thread?

The only thing I seem to be able to find is "Post Reply"...Where do I go to post a brand new thread?

 

[noccy]

Well....Find the right forum and hit the new thread button....

 

[dcx693]

Create a union query. Read in the Access online help about it. Basically, you go into your query design view, switch to SQL view (because the queries cannot be graphically represented) and then input some SQL like this:

SELECT * FROM table1 UNION (SELECT * FROM table2 UNION (SELECT * FROM table3));

Access will match up the columns easily if they all have the same number of columns in the same positions.

By default UNION queries exclude duplicates. If you want duplicates, use UNION ALL.

 

[noccy]

And how would the syntax be with 2 tables/queries?

And what about field names? What will they be?



...Well i found out =)

I got rid of the () and the field names solved by Select As

Thanks for your help on a Sunday =)

noccy