rbickings

Filtering Subsummary Count Results

Discussion created by rbickings on Mar 3, 2017
Latest reply on Mar 3, 2017 by philmodjunk

Good Morning,

I have developed a FMP database for a local church over 2 years time, replacing an old windows only DB that was 15 years old.  This database is hosted inside with a FileMaker Server 15 server and has recently gone live.  I have a rather complex attendance module that works well but some of the reports they require are rather complex and I am reaching the limits of my knowledge.

 

For instance, they would like to know how many people attending only 3 or less times in the last 6 months.  The data is all there, and if I use subsummary reports and Grand summaries (using the count function), I can get each individual over a date range with their number of attendance occurrences displayed.  I want to then further filter that to only show those whose attendance occurrences is say 3 or less.  I can not for the life of me figure out how to constrain the found set further...if anyone has any ideas concerning this, that would be deeply appreciated.

 

Thanks,

RBickings

Outcomes