Using the COUNT function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a column with entries of "YES" and "NO" I need to prepare a query to
count the no of YES AND NO'S in this column.
Please help!!!!
Thanks
 
I have a column with entries of "YES" and "NO" I need to prepare a query to
count the no of YES AND NO'S in this column.
Please help!!!!
Thanks
Click to expand...

Is it a Check box field Yes/No or a Text datatype field "Yes"/"No"?

Check box field:
=Abs(Sum([CheckBoxName]))

If it is a Text datatype field "Yes" or "No":
=Sum(IIf([FieldName]="Yes",1,0))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Dcount (multiple criteria) 3
Excel Count from last specific text 3
Office 365 Word - word count 1
Count function help 3
ACCESS - how do I apply a IIF = statement without parameter value prompt. The two column comparison is count 1
Count records in printout 1
Sum records in column continued...multiply count by 5 --------M--- 2
Count the columns from one sheet and paste it in another sheet 0

Back
Top