I have a table named tblOrgRegistrations. Sample data from that table is attaced to this question. There was a mistake made that allowed duplicate entries into the table. The RegID, ActivityDate, HourFrom, HourTo cannot overlap in timeframe.
Is it possible to find all the records that are duplicates where times overlap? For example, in the attached document, the times overlap for RegID number 35. He has 9 to 10 and 9 to 11. Unfortunately I need to identify all these overlaps and correct them. How can I query to find all these duplicates.