How to Determine Sex?!

[Nutty_natty_24]

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

[Genx]

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

[IdealData]

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

[Nutty_natty_24]

Thanks. I shall try it now.