E
EaglesNest
Hi all,
I would like to create a query or report that contains only those items from
table 2 that do not match items in table 1.
Explanation:
I have two tables with similar information in them. One is an original and
one is new updated table with new products added to it.
I have both tables imported to Access as TableOLD and TableNEW.
TableNEW contains OLDItems + (NewItems) - (deletedItems)
TableOLD contains ALLOLDItems
I want to compare the two tables and extract only those items in TableNEW
that do not match any Items in TableOLD. The result should be a list all new
items items have been added to TableNEW that were not included in TableOLD.
Preferably the list would be a new table called NEWItems
I hope I have explained this right.
Thank you in advance for the help.
I would like to create a query or report that contains only those items from
table 2 that do not match items in table 1.
Explanation:
I have two tables with similar information in them. One is an original and
one is new updated table with new products added to it.
I have both tables imported to Access as TableOLD and TableNEW.
TableNEW contains OLDItems + (NewItems) - (deletedItems)
TableOLD contains ALLOLDItems
I want to compare the two tables and extract only those items in TableNEW
that do not match any Items in TableOLD. The result should be a list all new
items items have been added to TableNEW that were not included in TableOLD.
Preferably the list would be a new table called NEWItems
I hope I have explained this right.
Thank you in advance for the help.