Count only Yes values from a Yes/No field.

R

Rick B

Have you done a search? This is asked and answered very often.

Also, it is customary to post your question in the text field and explain
what you are trying to accomplish; not just putting a brief description in
the Subject field.

Do a search and read the previous posts on this topic.
 
N

NoviceIan

I have searched but I dont understand the answers so I thought I'd post my
own. I know it is customary to post information as well I accidently pressed
enter instead of tabs after stating the subject sorry.
 
J

John Spencer (MVP)

Add a calculated field to your query.

Field: CountYesForA: Abs(Sum(FieldA))
Group By: Expression

To start at the beginning,
open your query (assume you have one) in the grid design view
Select View: Totals from the menu - a new line will appear in the grid area.
The line will be titled Totals and will default to GROUP under every field
Insert "CountYesForA: Abs(Sum(FieldA))" (NO QUOTE MARKS) into a blank field
Select Expression for it in the Totals line
 
Top