how do I pull all records from all tables in a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to display all records from 10 different tables in access. The
tables are being fed by data that is updated constantly by users using forms
through which to input that data. I want there to be 1 common table or form
in which I can display all the data from all the users including all the
updated data.
 
Hi,

If you find yourself with ten tables with the same data except that it's
from different sources, there's probably something wrong with your data
structure. Normally there'd be one table with an additional field to
show the origin of each record.

Meanwhile, you can use a Union or Union All query to pull records from
multiple tables. See Help for details.
 
Back
Top