Adding total number of Yes's in Yes/No field

C

CEV

Hi, I have a report based on a query that contains a Yes/No field. How can I
get a total count of record's marked "yes"? I will group them by another
field called "department" and then I want a grand total at the bottom of the
report.

Thanks,

CEV
 
F

fredg

Hi, I have a report based on a query that contains a Yes/No field. How can I
get a total count of record's marked "yes"? I will group them by another
field called "department" and then I want a grand total at the bottom of the
report.

Thanks,

CEV
Click to expand...

Add an unbound text control to the report.
Set it's control source to:

=ABS(Sum([CheckBoxField]))
 
G

Guest

The query would look something like:

SELECT DEPARTMENT, SUM(ABS([Yes/No Field Name])) as CountOfYes
FROM yourTable
GROUP BY Department

HTH
Dale
 
C

CEV

That did what it should. Thank You. Now on the report how do I get a grand
total at the bottom?

Thanks,

CEV

Dale Fye said:
The query would look something like:

SELECT DEPARTMENT, SUM(ABS([Yes/No Field Name])) as CountOfYes
FROM yourTable
GROUP BY Department

HTH
Dale

CEV said:
Hi, I have a report based on a query that contains a Yes/No field. How
can I
get a total count of record's marked "yes"? I will group them by another
field called "department" and then I want a grand total at the bottom of
the
report.

Thanks,

CEV
Click to expand...
Click to expand...
 

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

Countif on qry 6
Counting yes/no selection in a query. 3
how can I have access total the number of yes's in a yes/no col.? 2
Count Check boxes and create short report 10
Access Dcount (multiple criteria) 3
Yes / No query problem 4
Count text values in a Access Field 0
Counting yes/no fields 3

Top