Counting yes/no in query

  • Thread starter Thread starter Katt
  • Start date Start date
Hi Katt

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

Regards
JulieD
 
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
 
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
 
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
 
Back
Top