..wanted to get rid of duplicates
hm..what duplicates?
from ur example ID hold autonumber field which is not duplicate..

Step two.
Make a table to hold these matched IDs (tblMatched - ID - Number-long)
Make an append query using the above query to put the Ids into the tblMatched - Save this too.
can u show the code for it??

Code:
DELETE *.tblData
FROM tblData Left Join tblMatched ON tblData.ID=tblMatched.ID
WHERE tblMatched.id is Null
if it's NULL..can it be Joined?

sorry if i'm not quite understand