3 Replies Latest reply on Aug 13, 2012 10:39 AM by philmodjunk

    Report, counting the number of unique values in a field

    JoelMG

      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