We have two tables,
We are in middle of importing these data into a new platform.
Since we realized there're duplicate records in Employeestbl (according to email), we want import only those who have the latest note (according to date field).
Therefore I would like to have the SkipImport field updated to 1 for all those that dont have the latest note.
However if there is no note whatsoever under that email, then all records should be imported.
In addition I would like to merge all notes into one employee records.
Meaning all notes under same email should be transferred to the Employee record having the latest note.
What is the easiest way to accomplish it?
Work could be done either in SQL or in Access.
Thanks in advance.