Counting yes/no in query

[Katt]

I am trying to count only the yes check boxes in a query.
How do I restrict count?

 

[JulieD]

Hi Katt

if in the criteria line you put
yes
then only the yes lines will be included in your count

Regards
JulieD

 

[Guest]

When I put yes - there is no change. It seems to be
counting the number of entries and not the number of
yes/no answers.
How do I get the query to pay attention to yes/no (count
number of yes) instead of "count total number of records".
-Katt

 

[Duane Hookom]

CountYes: Sum(Abs(YourCheckBox))

 

[Guest]

In addition to putting yes in the criteria, turn on the Totals options. It's that backwards E in the tool bar, epsilon I think. Then under the field name in the query, change "Group By" to "Count". You have to create another query with it's data source being query you asked about. Now, choose the field from the parent data source "CountOfYour Field Name". Turn on totals, then choose SUM in the totals line.

I don't know of any other way around having 2 queries.

Tyler

 

[Guest]

In addition to putting yes in the criteria, turn on the Totals options. It's that backwards E in the tool bar, epsilon I think. Then under the field name in the query, change "Group By" to "Count". You have to create another query with it's data source being query you asked about. Now, choose the field from the parent data source "CountOfYour Field Name". Turn on totals, then choose SUM in the totals line.

I don't know of any other way around having 2 queries.

Tyler