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

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

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

Thanks. I shall try it now.