I have Access 2013, and am confused on how, if at all possible, to delete specific duplicate values. I have three columns of data,Enrollment_Key, StudentID and Enrollment Date, and I want to delete all the duplicate studentID's on the same date. So if a student had more than one enrollment on the same day, i want the student ID to show up only once, but if the student had more than one enrollment, but they were on different days, it's fine. I basically want to make sure there aren't any duplicate student id's on the same day. Does anyone know what SQL code i can use?
Thanks