Finding duplicates within a date range

[obesefeline]

I have records for events at bookstores. Some stores have multple events. I want to Find those stores with multiple events with a date range. With Date1...Date2 in the date field and ! in the store ID field, the found set includes stores that have only one event within the date range. These store do have additional events outside the date range. Why does the Find include stores with only one event within the date range?

[BobWeaver]

The "!" symbol for finding duplicates doesn't work correctly when combined with other search criteria. The other criteria is ignored. If you are working with filemaker 6, you can do this with to finds. First do a find on the date range, and then do a find for duplicates in the store ID field using the constrain option. If you are using 5.5 or earlier. You will need to use a script to find the duplicates. Use the example in the Filemaker manual at the bottom of page 10-13

[obesefeline]

Thanks for the feedback. I've used scripts to Omit dups, but this time it's records without dups I want to Omit. Since I'm still on 5.5, I reckon I'll have to go the scripts route. The Contrain option is definitely a welcome addition in 6.

Doug