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?