var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I have an Access table with member details, including their gender (yes/no field type - yes for male).
I want to use the DCount function to get the number of female members.
When i enter this expression i get the total number of members:
Now to get just the female members i add criteris "No"
DCount("[gender]";"Members";No) - but this returns a result of 0 which is incorrect. The stange thing is that if i enter criteria "Yes" i get the total number of members and not males.
What i'm trying to accomplish eventually is to calculate the percentage of female members. "female members/total members*100" so i need the number of females so i can use this equation.
Anyone have any ideas? I'd really appreciate the help.
P.S. I'd like to solve this with just a simple select query and no SQL statements
Try using this, for count of females:
or this, for count of males
Thanks to all who tried to help
This i show i eventually managed to solve it:
Total: Group By
Field: Total members: DCount(“[MemberID]”;”Members”)
Field: Total female: MemberID
Field: Percentage: Format([total members]/[total female];”Percentage”)