Comparison between two Access tables

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

re: Comparison between two Access tables

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

<lee.davies@flight-refuelling.com> wrote in message
news:1103013724.706726.224220@z14g2000cwz.googlegr oups.com...[color=blue]
> 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
>[/color]

re: Comparison between two Access tables

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