Two Table Into One Table

  • Thread starter Thread starter chieflittlehorse
  • Start date Start date
C

chieflittlehorse

I'm trying to combine two tables into one table using certain fields
which both have in common. I have two PRODUCT TABLES, one for standard
products, and a secondary table for products that require bits of
information such as weight, height, length, that do not apply to the
first table.

Now I would like to have both product tables to show as one list, I've
tried queries but they just seperate the two tables. Any help on this
would be appreciated.
 
It sounds like you are saying that you have one set of products in table1,
and a mutually exclusive (i.e., non-matching) set of products in table2.

If you want to see a list of all the products, you could use a UNION query
to combine a selection of table1 items and a selection of table2 items.

But depending on what you want to do next, the UNION query may not meet your
needs -- it will only display the full list.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top