Two Table Into One Table

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update Two Tables Using One Form Contents 0
Fill in multiple fields with one lookup 0
Access Passing the value to a table 1
Query problem 7
Contents of a drop down box based on the selection in another drop 1
how to combine two tables into one table 2
Update box with combo box 2
Comparing table data and adding differential information 1

Top