I have 2 identically formatted inventory tables in Access. One created yesterday and one created today.
The old one is AITCURRENT-2011-02-28
The one from today is AITCURRENT
I would like to know what has changed from AITCURRENT-2011-02-28 to today.
For example a field called STATUS could have changed from OnShelf to OnOrder - I need to know that field changed. Also the responsible manager could have changed in the TechContact field and so on.
Thanks in advance.