Finding differences between two tables

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

Guest

I have a problem and I know there MUST be an easy solution. Please help!

I want to take two tables and find the differences. In other words, I have one table on Monday. Then some records are added to that table, or values change in current records, and I get another file on Tuesday that has all the original records (from Monday) and the new records. It is cumulative.

I need to be able to output ONLY the records that have been added or changed. Any suggestions?

I had originally considered combining the two files (using an append) and then using a Find Duplicates. Deleting the duplicates should then reveal those that are different, right? For some reason my Find Duplicates query is not working properly. Any other ideas that might make this work?

thanks!
- S
 
One way that might work for you is to add a new field to
your table called 'Date_Added' or something of that
nature. The field type will be 'Date/Time' and
the 'Default' value will be Date(). Now everytime a
record is added to your table, the new field will
automatically update.

So now it's a simple matter to write a query with that
table and using your 'Date_Added' field to set your
desired criteria.

-----Original Message-----
I have a problem and I know there MUST be an easy solution. Please help!

I want to take two tables and find the differences. In
Click to expand...
other words, I have one table on Monday. Then some records
are added to that table, or values change in current
records, and I get another file on Tuesday that has all
the original records (from Monday) and the new records. It
is cumulative.
I need to be able to output ONLY the records that have
Click to expand...
been added or changed. Any suggestions?
I had originally considered combining the two files
Click to expand...
(using an append) and then using a Find Duplicates.
Deleting the duplicates should then reveal those that are
different, right? For some reason my Find Duplicates query
is not working properly. Any other ideas that might make
this work?
 
Thanks for the suggestion, Jim.

The problem with that is that we do not generate the file. It comes from a vendor and they will not add a date_added or date_modified field. That would make it easier on us, wouldn't it? hehehe

So in other words, the date_added field would always be the same for all records in each table (daily data dump file imported) because they all come in at the same time.

Unless I'm understanding your suggestion incorrectly, I don't think it's going to work. But thanks for the try! :-

Any others? hehe

- S
 
Back
Top