Query to select the first record in a group of repeating records

[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.

 

[sukip]

Look up DISTINCT keyword under Access Help..

 

[young]

Goup it and then select min.