AnsweredAssumed Answered

Report, counting the number of unique values in a field

Question asked by JoelMG on Aug 13, 2012
Latest reply on Aug 13, 2012 by philmodjunk

Title

Report, counting the number of unique values in a field

Post

I need to generate a report (using Filemaker Pro 11) where the number of unique values of a particular field are counted.  (Specifics: Multiple schools participating in multiple events; I need a count of the number of schools participating.  If a school participates in multiple events, it is just counted once.)

I'd appreciate any help in how to do this.  The "!" to find duplicates isn't much help.  I tried "omitting" "!", but that doesn't help either.

Thanks for any ideas.

Joel Goodman 

Outcomes