sticking 2 tables together

[hibster]

Hi Board,

i have 2 tables of the same data (headings), but for different periods. whats the easiest way to attach them together to make 1 table with both sets of data in.

Cheers

Hibs

 

[Norie]

Perhaps a UNION query.

SELECT * FROM TABLE1

UNION

SELECT * FROM TABLE2

 

[hibster]

any chance of some instructions on this union query, i don't kow how to do it.

Thanks

 

[Joe4]

Its pretty easy. All you are doing is putting the word UNION between the SQL code of each query. And you can get the SQL code of each query pretty easily in Access (it is one of the view).

Here is how you do it:
As long as both of your queries all have same fields in the same order, open one and switch to SQL view. Copy your code, go to the other query, go to SQL view, and add the word UNION at the end (but before the semi-colon), and then paste the other SQL code.

 

[Joe4]

Actually, I just noticed you are working from tables, not queries, which is even easier. As long as they are both set up exactly the same, start a new query, go to SQL View and post Norie's code and replace Table1 and Table2 with your actual table names.

You will now have a query that combines your two tables. You could use a Make Table query to write the results back to a Table, but that ofteny isn't necessary, as you can use Queries for almost anything you can use Tables for.

 

[hibster]

tried that and it does not work

SELECT
FROM [Jan - July 07] union FROM [Jan - Dec 06];

i am rubbish at this. how do you guys learn this stuff?

 

[hibster]

i think i did it!!!

cheers all.

 

[Samnuni]

Does the UNION query remove any duplicate entries?

 

[Norie]

hibster

Could you post your solution?

Might help others

Samnuni

If you just use UNION the answer is yes.

If you use UNION ALL you get everything.