Newbies Nutty_natty_24 Posted April 22, 2006 Newbies Share Posted April 22, 2006 Hi. I am new to File Maker. Currently using File Maker Pro 7.0 designing a database for hospital use. We have designed our forms and stuff. One of the field is gender. How can I COUNT the number of Males and the number of Females in that field? I have the GENDER field as a Pop-Down Menu. Thanks Link to comment Share on other sites More sharing options...
Genx Posted April 22, 2006 Share Posted April 22, 2006 You could create a global field, store the value "male" in it. Then self join the global field to your gender field in another copy of the same TO (table occurance). Finally create an unstored calculation, with number result: Count(RelatedMaleTable::Somefieldthatwillneverbeempty) Repeat for female, unless you have to specify a gender in which case you could just use Get(TotalRecordCount) - Count(RelatedMaleTable::Somefieldthatwillneverbeempty). Anyway the topic name was fun, goodluck ~Genx Link to comment Share on other sites More sharing options...
IdealData Posted April 22, 2006 Share Posted April 22, 2006 Nice one Genx, and that's probably the way some of us advanced users would do it, but I notice Nutty_natty_24 is a bit of a beginner... I'm attaching a working file to demonstrate the use of summary fields and a simple numeric equivalence for counting. GenderCount.fp7.zip Link to comment Share on other sites More sharing options...
Newbies Nutty_natty_24 Posted April 26, 2006 Author Newbies Share Posted April 26, 2006 Thanks. I shall try it now. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6568 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now