Deleting Unwanted Records

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

Joe

I have table that contains these fields:

IDField (unique), Call#, Unit#, DateTime1, DateTime2,
DateTime3

DateTime1...DateTime3 each contain different Dates/Times
but each field sometimes contains more than one value, and
that causes multiple records with the same Call#. I only
want the MIN DateTime1, MIN DateTime2 and MAX DateTime3
for the records that have the same Call# and Unit#.

I created a query based on a combination of MIN and MAX
values for these fields and sorted it to have the record
that I want appear first in the file, and this works
fine. However, because of the fact that they contain
different values, I still have the remaining records that
I don't need left in the file and this causes problems
with my subsequent time calculations.

How can I delete all of the ones that I don't want,
perhaps using a query?
 
Back
Top