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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Thank you so simple whew!!!

A follow up question is. Is there any way to tell what file it was in
originally?
 
How would you tell a (human) assistant how to tell "which file it was in
originally"?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
You must log in or register to reply here.

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

VBA - retrieve data on last create named range from previous inserted named range 0
Extract New Items after comparing two different tables. 1
MS word Find and Replace using Regex - Help required 0
Daily Make Table Query 1
Comparing columns in two otherwise identical Tables 5
Comparing Possible Like Records 5
Excel Comparing two columns 1
Access Sequentially numbered column that resets with each new sample 0

Back
Top