save first record of duplicate (1 Viewer)

[tubar]

my query lists duplicate records which I append to a new table. from that table I would like to delete the duplicates but save the first record of each duplicate. example the fields are employee and date worked. I would like to keep joe smith 1/1/14 but delete the other joe smith 1/2/14 and joe smith 1/3/14

any suggestions

 

[Mihail]

This can be an option (approach)
Recordsets for Beginners - Access wiki - Access Help and How-to - Microsoft Office by UtterAccess.com

 

[plog]

Yes, better describe your situation. 'Joe Smith, 1/1/14' is not a duplicate of 'Joe Smith 1/3/14'.

Provide sample data from your table (include field and table names) and also provide what data should result from that sample data once you've done the process you want done. Use this format for posting data:

TableNameHere
Field1Name, Field2Name, Field3Name
David, 1/2/2009, 71
Sally, 3/8/2007, 44


Also, what's the ultimate goal of this thing? Generally, you don't move data around, deleting and appending data. Usually, you aim to produce a SELECT query that will generate the ultimate results you want without using any action queries (i.e. UPDATE, MAKE TABLE, DELETE). So explain the big picture.

 

[namliam]

Select Fullname, min(yourdate) from yourtable group by FullName

That kind off thing?