Help with a Query

[Tmconsult]

I had to import some old data to my access database. this data lists a persons name with his/her year. ex.

Doe, r1
Doe, r1
Doe, r2
Doe, r2
Doe, r2

I need to make a query that will just select the first record of these repeating records. so after I run the query I get a table with

Doe, r1
Doe, r2

Is this possible? any help would be greatly appreciated.

 

[tempclerk]

If you just try to append all the records to a table with those two fields chosen as the primary key (no duplicates) it will append the first and discard all the extras.

 

[BoxHead]

Tmconsult, you can set the properties of your query to only output 'unique values'. That should eliminate the duplicates.

HTH
John