Tricky Query

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?

what do you mean "add a second"?

like add 1/60 of a minute? (second) to the visitTime field?