linking separate tables into one table and one report

[Timothy Hollis]

I have three separate tables in one folder that I would
like to combine and then create one report. I can't seem
to export data from one to the other and I know there
must be a simpler method.

 

[Rick B]

Tables or files?

If you have three tables in a database, then it is very easy to build a
query pulling data from all three tables (that's kinda the whole point of a
relational database).

If you have them in three separate mdb files, I would personally open one
database, go to the 'tables' tab. Click the 'New' button, select "Link
Table" and then locate the next table to include. Repeat this process for
other tables.

This will basically put a path to these tables in your database. It will be
almost invisible to you as you use the tables; it will be just like the
table is in your open database.

Hope that helps,

Rick B


I have three separate tables in one folder that I would
like to combine and then create one report. I can't seem
to export data from one to the other and I know there
must be a simpler method.