Delete Duplicates in Select Query

  • Thread starter Thread starter whicks
  • Start date Start date
W

whicks

I have a table of employee information.

EMPL_ID (Long Int)
NAME (Text)
HIRE DATE (Date/Time)
REHIRE DATE (Date/Time)
TERM DATE (Date/Time)
JOB TITLE (Text)
LOCATION CODE (Long Int)
etc, etc

I'm trying to delete duplicate records but keep the MAX term date.
Interns come and go multiple times. So, isn't the option because each
row is different in minor ways. I use the Group By MAX on the TERM
DATE field in design view but it does not remove the duplicate
fields????

Why is this?
 
I'm trying to delete duplicate records but keep the MAX term date.
Interns come and go multiple times. So, Unique Records isn't the
option because each row is different in minor ways. I use the Group
By MAX on the TERM DATE field in design view but it does not remove
the duplicate fields????


Why is this?
 
Back
Top