Delete Duplicates in Select Query

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?
 
W

whicks

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL Need for Duplicates 2
SELECT MAX DATE 2
Delete Duplicates except newsest Date 14
update table using a Query 3
delete duplicates 5
Prevent Duplicates Under Certain Conditions 6
Restrict Duplicates In A Query 1
Delete duplicates based on time 2

Top