Deleting Duplicates

[MikeSr]

I have read the post in this forum regarding how to delete duplicate records.
The method I am using is to create a "Make" query, with the "Unique" values
set.
Here is the problem:
Table structure has 10 fields
ID - date time - data1- data2 - through data8
When I build the Make query I can only use the data1 through data8 fields.
This does indeed work perfectly in deleting the duplicates. But I need the
data time field along with the record in the new Table. I can't include it as
the time is always differant and it will not permit the removal of the
duplicate records. Its the data that can is duplicated. That is what I need
to get rid of.
I hope I am making this clear. So in the end, I want data records that are
not duplicated, and timestamps to follow. just can't figure out how to get
that time stamp back in the table.

 

[Bob Barrows]

I have read the post in this forum regarding how to delete duplicate
records. The method I am using is to create a "Make" query, with the
"Unique" values set.
Here is the problem:
Table structure has 10 fields
ID - date time - data1- data2 - through data8

Is ID an autonumber field?

When I build the Make query I can only use the data1 through data8
fields. This does indeed work perfectly in deleting the duplicates.
But I need the data time field along with the record in the new
Table. I can't include it as the time is always differant and it will
not permit the removal of the duplicate records. Its the data that
can is duplicated. That is what I need to get rid of.
I hope I am making this clear. So in the end, I want data records
that are not duplicated, and timestamps to follow.

Err ... which timestamp for each unique record? The latest one? The earliest
one?

just can't figure
out how to get that time stamp back in the table.

Instead of Unique, use a grouping query: group by the 8 fields that should
have had a unique index on them in the first place, and use an aggregate
function such as Max() or Min() on the date time field.