delete duplicates with 6 fields

[sal21]

How to delete dupliates...

consider all values in all fileds

for example viale verona with CIVICO 6

i use ado and vb5 and access database

[HansV]

Without a primary key it's impossible to decide which record to delete.

You could create a new table with unique records:

SELECT DISTINCT R05.*INTO R05_UNIQUE FROM R05