Linking Tables

[Jim Marsh]

I'm trying (without success)to create a table composed of
data from several other tables (via linking) within the
same database. Thanks in advance for any help.

 

[Armen Stein]

I'm trying (without success)to create a table composed of
data from several other tables (via linking) within the
same database. Thanks in advance for any help.

Hi Jim,

Assuming your tables are already linked, then you combine them using
queries, not tables. Your data is stored once in the original table
only.

If you really need to actually create another table with this data,
build an Append query which joins the original tables and loads the new
table.

Hope this helps,