Delete duplicates from sql query based on import date

[damngroundhog]

Hello. MS Access and sql user for 2 entire days! I have researched and found out how to delete duplicate records using 2 sql queries. First one

 SELECT last(id) as lastid INTO temp_delete FROM tbl1 GROUP BY sourceid HAVING count(sourceid >1);

Second one

 DELETE DISTINCTROW tbl1.* FROM tbl1 INNER JOIN temp_delete ON tbl1.id = temp_delete.lastID;

Each row of data has an import date. I am looking to compare the import dates and use the older one. IE if one import date is 8/15 and the other is 8/22, i want to keep the 8/15 one. I am unsure how to create a comparison in this. Any help is always duly appreciated. Groundhog

[June7]

The older one of what? Are there multiple same ID values in this data and you want oldest date record for each ID?

Post sample dataset.