Hello Everyone
I am totally new to the Access database process.
In my project, I import two file (excel and html) generated from SAS application into access database (based on some requirement) on a daily basis and after that export the data into excel format.
The main problem is that the exported excel sheet contain same records with different download date. Below example
EID ENAME job download_date 101 ABC clerk 12/01/2015 15:41:57 101 ABC clerk 13/01/2015 15:41:57 101 ABC clerk 18/01/2015 15:41:57
I want to remove those duplicate records only if data in three fields (eid, ename and job) are same. For the above scenario, I want data with old download_date.
Can anyone help me how to fix it.