Internal dedupe

[seanp13]

Hi,


new to all this, so any help most welcome!

I need to internally dedupe some files and leave just one copy of each duplicate record in the database?

Kind regards
sean

[orange]

Do some research on table design and normalization. You really need to be aware of the concepts involved.

Excellent tutorial for database and table design

[John_G]

If the records are exact duplicates (i.e. all fields are the same), then you could make a totals query with group by on all fields, and use that query as the source for a new table containing no duplicates.