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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

vulcan88 - 30 Mar 2005 01:05 GMT

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.

Reply to this Message

John Nurick - 31 Mar 2005 07:24 GMT

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.

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

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Reply to this Message