P PR2AledE Registered User. Local time Today, 10:42 Joined Mar 21, 2003 Messages 16 Apr 2, 2003 #1 I have a query and in one of the fields I want to count the number of True Values that have been chosen. How do I do this?
I have a query and in one of the fields I want to count the number of True Values that have been chosen. How do I do this?
K KKilfoil Registered User. Local time Today, 05:42 Joined Jul 19, 2001 Messages 336 Apr 2, 2003 #2 Since 'False' evaluates to '0' and 'True' evaluates to '-1', just create a summary query and sum your Boolean (Yes/No) field.
Since 'False' evaluates to '0' and 'True' evaluates to '-1', just create a summary query and sum your Boolean (Yes/No) field.
