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

V

vulcan88

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.
 
J

John Nurick

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Consolidation Table from Different Excel Tabs with Different Format 1
Adding data to MS Access from csv file 0
How do I clear a form? 0
Creating a Chart on form from selected data in query. 0
Copy previous record into form field 0
QBF & Query Malfunction 0
Access 2013: Form problem in reading data tables; relationship one-to-one 0
Page numbering with Merged Document and IF statements 1

Top