Hi All

I have the following SQL to find duplicates

SELECT VisitMember, VisitTime FROM tblVisits
GROUP BY VisitMember, VisitTime
HAVING COUNT(*) > 1

Now what I want to do is add a second onto the duplicate VisitTime so it doesn't conflict anymore.

Any Suggestions?