AnsweredAssumed Answered

Gender Count Question

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

Title

Gender Count Question

Post

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.

 

Outcomes