combining queries

[Guest]

I have 16 queries that report data from 16 tables in exactly the same
structure. Is there a way to combine them together into 1 table or, for that
matter, 1 query that shows the result for everything? It's a part catalogue
that has PART NUM, DESC, COST and RETAIL. I'd like to be able to work with a
single table instead of all the individuals.

 

[Douglas J. Steele]

You can use a Union query to combine the data from each of the 16 tables,
but Union queries aren't updatable. Assuming you're going to need to make
changes to the data, you'd be much better off loading everything into a
single table using a series of Append queries.