By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,398 Members | 944 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,398 IT Pros & Developers. It's quick & easy.

Table comparison

P: 9
I have 2 tables with different versions in access. Both are same but the latest version obviously has some new records and some deleted records from the previous version. How would I compare the new table with the old one? I have a common field called MFI_ID having the value AT00100, AT10000 etc, in both the tables. I need to put the query and find out the new records in the new table as well as deleted records from the old table. The comparison is as follows (example):

Sheet.MFI_ID Sheet1.MFI_ID
AT00100 AT00100
AT10000 AT10000
AT12000 AT12000
AT14000 AT14000
AT14200 AT14200
AT14900 AT14900
AT15000 AT15000
AT16000 AT16000
AT17000 AT17000
AT18100 AT18100
AT18120 AT18120
CY151012 AT19230
CY151032 AT34000
FR0010137596 AT12312
CY155060 AT13452
Aug 31 '07 #1
Share this Question
Share on Google+
5 Replies

Expert Mod 10K+
P: 12,396
A left join where Sheet1 is null will give you deleted records.
A right join where Sheet is null will give you new records.
Aug 31 '07 #2

P: 9
Thanks again. Is there anyway these two could be used together in a query?

Sep 6 '07 #3

Expert Mod 10K+
P: 12,396
No, you can't combine the two joins in that fashion. You can create two queries and then combine them in another query though. When you run the third query, it'll automatically run the first two.
Sep 6 '07 #4

P: 9
Thanks for your help again. I really appreciate it.

Sep 9 '07 #5

Expert Mod 10K+
P: 12,396
Not a problem, good luck.
Sep 10 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.