Access 2010 Delete Query Question

[scheibla]

I have an access database where I am trying to use a query to remove duplicates from a table. My Fields are: MRN, APPT MADE DATE, Division, and User in the table Failed Complex Scheduling.



I have selected the delete query to use, but I am unsure what my criteria should be for this situation. I need MRN and APPT MADE DATE to be duplicated in one or more rows. However, in those rows Division and User cannot be duplicated.

I started by doing a duplicate query so that all of my MRN and APPT MADE DATEs are narrowed down to just duplicates, now I am unsure how to get rid of duplicates in the Division and User fields.

I have been Googling and playing around with this for hours to no avail. I am fairly new at Access, VBA, and SQL (gotta start somewhere!). If anyone could lend a hand - it would really be appreciated.

Edited for more info: Adding Distinct after Select in SQL has not worked. Also, going to Property Sheet and changing Unique Values (and Unique Records) to yes did not work either.

[June7]

So all 4 fields must be considered in determining if the record is unique or duplicate? If the Division and User pair is duplicated for any MRN and APPT MADE DATE pair then the record is duplicated and one must be removed?

[scheibla]

Yes, but all copies must be removed - not just one of them. It is a different type of scheduling if Division and User are duplicated than if they are not. I am trying to determine what % of each type of scheduling we do.

[June7]

Provide sample data to test with. Can be an Access or Excel. Follow instructions at bottom of my post.