When Using the Duplicate Record Wizard query in MS Access 2000, the resultant output contains both of the duplicate records wherever a duplicate is found.

In my example, I have 17 pairs of duplicate records (34 rows in total). How do I ammend the Find Duplicate query, or otherwise, that will give only one record from each duplicate pair (so I am left with 17 non duplicate rows).

This has been bugging me for so long I can barely look at the screen any more.

Mike

Go into the query in design view and click the properties button for the query. Set the UNIQUE VALUES or UNIQUE RECORDS property to YES. Which to choose depends on what you are trying to accomplish. To decide this hit F1 and read the help text for specifics and other problems that this might introduce (like the records becoming un-updatable).

Many Thanks.

sometimes these things are solved by the easiest of solutions (i was dreading the reply being hundreds of lines long with VB code!!)

Mike

You are SO right. I spend hours working myself into a corner with 100 lines of horribly complicated code and someone comes along behind be and does something much more efficient and elegant in a few lines using a command or control I don't know. Thats life I guess. I am constantly reminded of my own weakneses and wish I knew more - I guess it will all come in time.