I have a database that I am working on and it updates from a master database. My project is to somehow when the database gets updated that an exception report is created it will show if the mileage of the things in the database changed since the last time it was updated.

Also the mileage can change by 2.5% but is not allowed to change more than that without being included in a report. The goal is to get to be able to make a query that will generate a report to send to all of the people in the field in order for them to check the mileages.

So does anyone have any ideas on how to accomplish this.

Anyone have any ideas.