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.