Find Records in Identical Tables

[jlo]

Monthly I bring in a txt file in Access. What I want to do is create a query
that will take the previous months data and compare to the new months data.
Both tables have the same fields.

The only fields that the data can change is in the following fields:
[Status] [Action] [T Date]

How can I capture what has changed in these fields on a monthly basis so I
don't have to do this manually?

There are thousands of records to go through.


Thanks in advance.

 

[John Spencer]

IS there a value in each record that uniquely identifies the record and can be
used to match to a specific record in the other table. Or are there multiple
fields in table one that can be used to match to a record in table two.

Are new records added to the file? Are records deleted from the file?



John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[John W. Vinson]

Monthly I bring in a txt file in Access. What I want to do is create a query
that will take the previous months data and compare to the new months data.
Both tables have the same fields.

The only fields that the data can change is in the following fields:
[Status] [Action] [T Date]

How can I capture what has changed in these fields on a monthly basis so I
don't have to do this manually?

There are thousands of records to go through.


Thanks in advance.

I would suggest adding a DateImported field to the local table. Rather than
importing the text file, you could link to it and run an Append query
appending it to the local table, adding a calculated field:

DateImported: Date()

to timestamp each record. You could then easily use a Self Join query to
compare data with a timestamp of 10/1/2009 with a timestamp of 9/1/2009.