Find Duplicate Records

[Skipi]

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

[John Mark Osborne]

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.

[Skipi]

Ahhhh, such a simple solution!

Thanks very much for your help.