Windows 7 64bit 
Access 2003
I have a database that takes a snapshot of a table from a mainframe. The query runs as a make table, and everytime it runs, it creates a new table.
The result of this, is a table of yesterday's data, and another table with today's data.
What I need, is a query that looks at yesterday's data, and compares it to today's data, and only shows me the whole record, where a change has been made, to any field.
The table I am taking a snapshot of, has 18 columns. A change can be made to the value in any one of these columns.
If the record is different today, from yesterday, I need to be able to capture this record. Any idea how to do this?
Reply With Quote
