Find only the records that do not have duplicates in 2 Tables.

B

Button1A

I have 2 Tables that are suppose to be the same, but there are additional
records in one and not the other. I need to retrieve a list of just the
additional records. How do I go about doing that?
 
B

Button1A

The problem is each table has
Account #: Shows up more than once. Company's send more than one payment
Amount of Payment
Date of Payment

So I need to run a query that has all the above fields the same, in order
for it to work.
 
R

Rick B

Why do you have two (almost) identical tables?

Why not just pick the bigger one and delete the other?
 
B

Button1A

They want to find out which payments did not get put into our system. Bigger
one is the one from corporate, and smaller one is what we had. Just need to
print out the ones that we didn't have, so we can correct the error on our
end.
 
R

Rick B

When you compare the tables, you will have to compare the account# and the
date or the account# and the amount, or some other unique combination. That
should catch any that are not in both tables.

If the data is already in a table "at corporate" it seems like it would be
easier just to share that data or import it in the future, rather than do
double entry. But that is another topic.
 
Top