earlier, i was trying to write a sql statement that would not copy duplicate values into a recordset. i found that you could do this using the DISTINCT keyword (fellow vb-world member, jlopez deserves some credit here). now i want to be able to identify those records that are duplicates and use them as part of an error log. but how do i capture them? are there any sql gurus out there? SQL for Dummies doesn't seem to be cutting it.

[Edited by dwhawley on 08-02-2000 at 04:36 PM]