Jump to content

How to Determine Sex?!


This topic is 5696 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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

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

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

This topic is 5696 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.