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.