[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

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

Posted on 2008-10-11
1
Medium Priority
?
241 Views
Last Modified: 2013-11-28
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?
0
Comment
Question by:bemara57
1 Comment
 
LVL 5

Accepted Solution

by:
Cvijo123 earned 2000 total points
ID: 22695583
Select
count(*) as count,
taskID
from yourTable
where completed = "YES"
group by taskID
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Recursive SQL is one of the most fascinating and powerful and yet dangerous feature offered in many modern databases today using a Common Table Expression (CTE) first introduced in the ANSI SQL 99 standard. The first implementations of CTE began ap…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question