Two Table Into One Table

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

 

[Jeff Boyce]

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

 

[SyntaxError]

I've tried the UNION QUERY, and it works perfect for what I need,
thanks alot.