This is my first post so be kind! I am having a problem with my Access 2003 DB. I have a duplicates query which searches the Main Table and brings back all duplicate records based on their Job Number. However now I want to create a delete query that looks at that duplicates query and deletes all the duplicate records with the oldest date, for example:
Job Number Imported Date
12345 28\04\2011
12345 24\02\2011
I would want to run the delete query and be LEFT with the below records:
Job Number Imported Date
12345 28\04\2011
So it deleted the duplicate record that was imported into the DB first (therefore its the oldest record out the two). Please can anyone help???
I'm not a DB master so presumably when someone lists code to put into the SQL view just talk to me like a newborn baby
THANKS!!