I can think of some very round-about ways to maybe do this with VBA, but I can't be sure it will work and I don't know enough about your data. Are there duplicate records in a table? Do the records have unique record IDs (primary key)?

To get rid of duplicate records in the data table, create a make table query using the table as the data source. Select all of the fields and either group the query (this will basically stack identical records together since you are grouping by all fields) or right click in the query design area and select "Yes" for "return only unique records". Run the query to create the new table and then replace your old table (after backing it up of course).
Source(s):
My braaaaaiiinnzz


Permalink | Report