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.
The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.