AnsweredAssumed Answered

finding duplicate values

Question asked by jpadman on Mar 13, 2009
Latest reply on Mar 13, 2009 by philmodjunk


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.