finding duplicate values
Description of the issue
I have Filemaker Pro v 8.0. I have tried to use the exclamation mark (!) to find duplicate values in a particular field. It does find many of the duplicates. However the found set always includes some unique values as well.Note, when I use the ! mark, I only use it in one field, and do not include it with other find requests. I have tried using it in a field that has text in it, and also tried it in a field which only has numbers. It fails to find all the duplicate values no matter what type of field.Any help with this issue would be appreciated.