Union Queries (1 Viewer)

[Varus Quai]

I am working on a project that required me to keep individual tables for records that could all be kept on one table, meaning they all have the same fields.

Is it possible to combine all these tables into one representation with a query?

This resulting table is also along the order of 70,000 records and can become larger. What is the max table size Access allows?

 

[jatfill]

yes, you can join tables together into a single query... create a new query, add all of the tables you wish to combine, and then link the tables according to your primary key, or related fields

as far as your second question, My understanding is that Access does not have a record limit, rather the database size is limited to 2GB. I've never come anywhere near that, so I haven't had the opportunity to validate...
HTH