Good morning Data Junkies,
I have an Access (2016) DB getting data from a connection to a SQL DB (coming out of our ERP). This DB is constantly receiving updates from many thousands of records, relating to jobs, operations and various manufacturing data fields.
My challenge is to identify which changes to individual records are driving overall trends or changes to sub-totals. So far, the only effective method (effective, but also very tedious) I have come up with is to manually save an excel version of the data and utilize basic formulas to compare 'snapshots' of the data. Is there a best practice for tracking the changes to the data coming into my Access DB in order to handle this task in a more automated manner?
Thanks in advance for your ideas!
Regards,
Quaker