Comparing Tables to Find new items added ( is it possible?)

S

sfleck

I have a linked table that has yesterdays data in it
I have a nother linked table that has todays data in it

I would like to run a query that showed me only the added items

Thank You in advance
 
J

Jeff Boyce

Start in the database window, looking at the tables. Click on the New
(Query) Toolbar tool, and select the "Unmatched" query wizard. It will walk
you through creating a query that shows records in one table that are not in
another.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
S

sfleck

Thank you so simple whew!!!

A follow up question is. Is there any way to tell what file it was in
originally?
 
J

Jeff Boyce

How would you tell a (human) assistant how to tell "which file it was in
originally"?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top