How do I count the number of records that are "true" in one column?

I have a bunch of records with one column called "completed" that's either yes/no. They are tasks, so I want to count the number of tasks that have a 'yes' in the completed field. How can I do this from the Report Wizard or with a SQL expressions?
bemara57Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Cvijo123Connect With a Mentor Commented:
Select
count(*) as count,
taskID
from yourTable
where completed = "YES"
group by taskID
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.