Query to Flag Database Changes

[pony08]

I need to build a Query that will look at a previous table and a new table and flag any changes...what is the best way to go about something like this?

 

[SOS]

Do you mean as in DATA that changed?

 

[pony08]

Yes...that is correct. It is involving specifications for SKU's. We want to flag and specs that change with a date so field staff know they need to review the revised spec sheets.

 

[pony08]

We want to flag any specs that change with a date so field staff know they need to review the revised spec sheets.

Sorry typo

 

[pony08]

thx...I will give that a try!