select distinct on 1 field only

[John Smith]

how do i select all the rows in a table not allowing duplicates on 1 of the
fields
ie :
table:

12 jka 0979
12 asdpfoiu 7087
13 lksafj 87

result:
12 jka 0979
13 lksafj 87

TIA

 

[John Smith]

Automatically delete duplicate records from a table
from access help did the job