I'm using a Microsoft Access database (not created in Access) in VB6. I need to be able to detect duplicate records using SQL.
Each record has an InvoiceNumber field which is a Long. Each InvoiceNumber should be unique but I don't want to use an Index to make the InvoiceNumber unique. (I didn't design the database, I just have to work with it.)
I want to be able to create a recordset that contains all duplicate InvoiceNumbers in the database.