MS Access Compare all fields in two tables <p>I am working on a project that has a definite start and end date, with data that will be produced daily. Every day I will be receiving a dataset with all the data from the start of the project until the previous day (e.g. on Day 10 I will receive the data from days 1 to 9, on day 11 I will receive the data for days 1 to 10 etc.). Each row of data will have approx 15 fields and I need to be able to highlight if any retrospective changes have been made to any of the fields in each row of data.</p> <p>Is there any way to do this?</p> <p>Many thanks in advance for any advice!</p>