Solved

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

Posted on 2008-10-11
1
232 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 500 total points
ID: 22695583
Select
count(*) as count,
taskID
from yourTable
where completed = "YES"
group by taskID
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Suggested Solutions

'Between' is such a common word we rarely think about it but in SQL it has a very specific definition we should be aware of. While most database vendors will have their own unique phrases to describe it (see references at end) the concept in common …
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

860 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