Removing duplicate records based on certain criteria

  • Thread starter Thread starter Joe
  • Start date Start date
J

Joe

I have a table that contains the following: a callnumber,
a unitnumber and a unittime. Because the unittime is a
different value for each record, I get the same callnumber
and unit number again and again in the table if the
unitnumber had different times. However, I only need one
record in the table that contains the same callnumber and
unit number (don't care about the unittime).

I want to delete any record that has a callnumber and a
unit number that is the same somewhere else in the table.

Any assistance will be appreciated.
 
After posting I realized one way to do this: create a
query to select only the minimum time (since they cannot
ever be the same in my situation). This got rid of the
duplicates for my purpose.

Still curious of other ways to accomplish the same.
 
Back
Top