AnsweredAssumed Answered

Gender Count Question

Question asked by ToddNolan on Feb 8, 2015
Latest reply on Feb 9, 2015 by philmodjunk


Gender Count Question


Thanks in advance for any suggestions.


I have a client database with many tables but I am dealing with one client_Table.


I have a script that finds client birthdays for each month of the year. In this script I use the Get(FoundCount) function to give the total birthdays for the month. I would love it if I could also count the number of males/females as well. Is there a filemaker function to accomplish this? I tried a loop inside of a script trigger after performing the find for those with birthdays in that month, but I could never manage to move my record from the first record found to the next. I was using Go to Record/Request/Page [Next; Exit after Last]


Is there a different way?

Thanks again.