August 9, 200619 yr Hi, I've a database that has test sheets each with a serial no. The problem is that this is the second year of testing and there are test sheets with the same serial for 05 & 06. I want to do a comparison between the 2005 results and the 2006 results. Can someone put me on the right track, as I'm going round in circles! Many Thanks, Skip
August 9, 200619 yr You can do a quick search for duplicates by entering find mode and typing and exclamation point into the serial number field. After the find is complete, you can sort the data so you can see duplicate numbers next to each other.
Create an account or sign in to comment