Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Counting "YES" values

Status
Not open for further replies.
czarjosh

czarjosh

Technical User
Jul 14, 2002
79
US
How do I count only YES values in a report? When i perform the count operation it is counting both check and unchecked.

Thanks for any help.
 
Sort by date Sort by votes
czarjosh

Yes and No are Boolean values, so you can't use Count.

Try
=Sum(Abs(([YourCheckBoxName])=True)

Tom
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

soloracer
  • Locked
  • Question
Problem using report recordsource values within report events. Error 2427 1
Replies
17
Views
391
soloracer
soloracer
Pack10
  • Locked
  • Question
Sub-Report text field truncates data at 255 characters with can grow = "Yes"
Replies
1
Views
117
Pack10
Pack10
ICCIIT
  • Locked
  • Question
How do we send a report to PDF with a "Where" clause or Add Where Clause to "OutputTo 1
Replies
3
Views
111
strongm
strongm
varadha72
  • Locked
  • Question
Display field value as column layout "Across, then Down"
Replies
9
Views
242
dhookom
dhookom
tinsar
  • Locked
  • Question
Report Counting and Grouping, rusty brain can't remember
Replies
0
Views
92
tinsar
tinsar

Part and Inventory Search

Sponsor

Back
Top