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 My YES Values

Status
Not open for further replies.
czarjosh

czarjosh

Technical User
Jul 14, 2002
79
US
In my Report I have a name with 5 check boxes to the rigth of that. At my page footer I would like a text box that counts all the YES values in my report. How do I add a sum control to the report.
 
Sort by date Sort by votes
Hi!

You can't in the page footer, it must be in the report footer or a group footer.

hth


Jeff Bridgham
bridgham@purdue.edu
 
Upvote 0 Downvote
in the report footer add a text field
=Abs(Sum([YOURTEXTFIELD]))

Hope this helps
Hymn
 
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
402
soloracer
soloracer
tinsar
  • Locked
  • Question
Report Counting and Grouping, rusty brain can't remember
Replies
0
Views
93
tinsar
tinsar
telephoto
  • Locked
  • Question
Counting checked boxes on a crosstab report 1
Replies
2
Views
125
telephoto
telephoto
Pack10
  • Locked
  • Question
Sub-Report text field truncates data at 255 characters with can grow = "Yes"
Replies
1
Views
117
Pack10
Pack10
RangerFan
  • Locked
  • Question
Counting check boxes that are checked on a report footer line.
Replies
6
Views
147
RangerFan
RangerFan

Part and Inventory Search

Sponsor

Back
Top