how to translate "row_number"?

[mfran2002]

i have some duplicates rows in my table and i have to keep only one of them

example:

field1|field 2|field3


johnboy|mick | jack
sara | fara | mara
johnboy|mick | jack
johnboy|mick | jack
sara | fara | mara
johnboy|mick | jack

i need:

field1|field 2|field3
johnboy|mick | jack
sara | fara | mara

without duplicates rows....


this query works on oracle:

select *
from mytable
where rowid in (select rid
from (select rowid as rid, row_number() over(partition by myfield order by myfield ) as rn
from mytable)
where rn > 1)

but i don't know how to do in access..

thanks a lot
mick