Sum in the Footer

A

AttackIP

In the Detail section of a report, I have a TextBox Iff /Then expression that
either renders the word "Off", or a calculated number. In the footer section,
how can I sum the number of times that the word "Off" (the True part of the
IIf /then statement) is the resultant?

Thanks!
 
D

Duane Hookom

You use something similar to the control source in the detail section. Change
the "Off" to the number 1 and sum it.
 
A

AttackIP

OK, that was too easy. Thanks!

Duane Hookom said:
You use something similar to the control source in the detail section. Change
the "Off" to the number 1 and sum it.
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

Page numbering with Merged Document and IF statements 1
(headers & footers Issue) I have 2 even pages back to back!! 1
Footer height is different between sections 2
Space at end of multi page list to accommodate new entries 1
Need VBA Macro to Loop through pages and print counter in footer of each page 9
iterating and modifying headerfooter objects 0
Running Sum 13
Summing in a Report Footer 7

Top