Hi,
Wonder if anyone can help, really stuck on this one and can't seem to work my way out of it even with reading many threads online,
I want to be able to take a table which is populated with imported data and compare it to the table of data that already exists within the database.
I want to be able to highlight with a query which records are different in the uploaded data to that of the existing data, I managed to get this to work in SQL using the except function however I am not able to use a web app for this project and have to use MS Access (not a problem, just can't seem to get the except functionality to work in Access).
Any ideas??