Sum in the Footer

G

Guest

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!
 
G

Guest

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

Guest

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

Summing in a Report Footer 7
Group last line of details and report footer 0
Running Sum 13
Reports, Sub-reports running sum and no data 2
In Footer - Sum a Detail textbox 2
Make appearance of a footer conditional 1
Referencing textbox controls 4
Adding a field (Unbound field) that adds a group of numbers 3

Top