Add tables

[Pauloandrade]

Hi,
I want to create a table that is the result of adding the records of two diferent tables. (Basicaly, I want to add two tables). Any ideas?
Thanks in advance,
Paul

 

[LonnieJohnson]

1. If by adding tables you mean taking all the records from one and adding them to the end of another, you can create a union query which stacks the records of two tables provided you have the same number of fields for both tables in your query.

Note: a union query is an SQL query that would look like...

SELECT * FROM TABLE1
UNION SELECT * FROM TABLE2;

Once you have the union query working then you can run a Make A Table query using the union query.

2. If you are speaking of combining fields of joined records, then you would just create a relationship of the two tables in a Make A Table query.

Hope I am close to what you want.

ljprodev@yahoo.com
Professional Development
MS Access Applications