Comparison between two Access tables

[lee.davies]

Hello,

Any help with this problem will be greatly appreciated.

I am trying to compare two tables containing similar bills of
materials, both tables have an ID(unique)field a PartNumber field and a
Description field. The part No and Description fields do have multiple
entries of the same data and cannot be unique. I need to extract the
common parts between both tables into a new table which only shows me
the data once.

Any Ideas !!

Thanks, Corky

[Squirrel]

Hi Corky,

Try running two queries, note they omit any mention of the ID field:

This first one has been saved as qryUnionPartDesc

SELECT tblFirst.PartNumber, tblFirst.Description FROM tblFirst
UNION SELECT tblSecond.PartNumber, tblSecond.Description FROM tblSecond;

followed by this make table query:

SELECT qryUnionPartDesc.PartNumber, qryUnionPartDesc.Description INTO
tblCombined
FROM qryUnionPartDesc;

HTH -Linda

<le********@flight-refuelling.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...

Hello,

Any help with this problem will be greatly appreciated.

I am trying to compare two tables containing similar bills of
materials, both tables have an ID(unique)field a PartNumber field and a
Description field. The part No and Description fields do have multiple
entries of the same data and cannot be unique. I need to extract the
common parts between both tables into a new table which only shows me
the data once.

Any Ideas !!

Thanks, Corky

[lee.davies]

Thankyou for you help it has worked perfectly.

After running the query's I have found that the common parts in these
tables do actually have different quantity's, is there any way in which
I can add a field into this query that adds the two qty's together and
displays it next to the part number and description ??

Regards

Corky