AnsweredAssumed Answered

Trying to use ! to find duplicate values

Question asked by blaise on Dec 28, 2017
Latest reply on Dec 31, 2017 by RalphLearmont

Using FMP16. I am trying to use ! to find duplicate values in a numbers field, that only has numbers it, with 2247 records. I know there are about 50 values in the list that are duplicates.

 

Here are my steps:

1. Select out the 2247 records that I want to identify duplicate values.

2. Click the Find button.

3. Click on the number field that I want searched and type !

4. Select "Constrain Found Set" from pull down menu.

 

Result is 2236 found items, which is obviously incorrect.

 

Thanks,

 

-Blaise

Outcomes