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. I use the Group By MAX on the
TERM DATE field in design view but it does not remove the duplicate
fields????
Anyways, does anyone have an example of some SQL to use here?
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. I use the Group By MAX on the
TERM DATE field in design view but it does not remove the duplicate
fields????
Anyways, does anyone have an example of some SQL to use here?