I have appended several tables to the bottom of another table, but i need to have the new table updated from the old tables whenever they are changed. Im sure it is something rather simple, but i am new to access.
Thanks in advance for your help

If you're still using your separate tables, but need them all in one table for data processing or whatever, consider using a UNION query instead of an append query and an additional table. Your data will always be up to date with the copy of the other tables you have.

SELECT blah, blah2, blah3 FROM table1
UNION
SELECT blah, blah2, blah3 FROM table2
etc...

Are the different tables being imported from satellite offices or something?

[This message has been edited by David R (edited 05-24-2002).]

Each table has 2 columns, one is a section of medical practice, and the other is the venue for learning. I made a different table for each section of medical practice, each of which has about 6 areas. I made forms using combo boxes to input the data into all of them. The problem i have now is that i am trying to make it so that i can get all the areas of medical practice that are to be learned through one method (morning report, or whatever) I tried to do this directly with a query but it wasnt working well because i can not make relationships due to my lack of similar data, so i thought that the way to do it would be to append them all together, and then simply make the criteria "morning report".

Can a union query also add them on the bottom of another table?

use all columns from union q in append q

Thanks a lot, im tried using a union query and it works perfectly