Find Differences in Tables

[mhirdes]

Hello,

I have two tables in identical format (comparing two weeks of product data). I need to create a query to identify all of the changes made to this data. I know I could write an Iif statement to compare each of the 70 fields, but I would like to not spend the rest of my life writing that.

Is there a simple way to do this? (Or at least some standard code out there I could use)

Thanks!

 

[pr2-eugin]

A small example will help us understand your problem better.. What is the data you are trying to compare?

Also by the sound of it, you have redundant data in two tables? Why?

 

[mhirdes]

I get dumps of system data each week, and I need to audit the changes made. The tables are identical in structure, and much of the data is the same. Product_Code is my primary key, but if any of the attributes change, I need to be able to find them easily. I have the tables set up showing current week and previous week data.

If there's a better way to do this than how I'm going about it, I'd love to hear about it! I need to start running this query tomorrow (and I'm an excellent procrastinator).