Simple counting problem in report

  • Thread starter Thread starter Todd
  • Start date Start date
T

Todd

I have a report that prints a list of Checkbox fields. At the very bottom,
I want the report to show how many "True" values there were in the [debt]
field. I've tried putting a textbox in the 'page footer' section with
various formulas with no luck. Can anyone please help? Thank you!!!
 
Todd,
To count True values:
=Abs(Sum([Debt]))

Place this control in the Detail section or in the Report Footer section,
not in the Page footer.

If you need the result in the page footer, place the control in the Detail
section.
Name it CountDebt.
Then in the Page Footer, add an unbound control.
Set it's control source to:
=[CountDebt]
 
Thank you! I had the right formula before, just put it in the wrong
section.


Fredg said:
Todd,
To count True values:
=Abs(Sum([Debt]))

Place this control in the Detail section or in the Report Footer section,
not in the Page footer.

If you need the result in the page footer, place the control in the Detail
section.
Name it CountDebt.
Then in the Page Footer, add an unbound control.
Set it's control source to:
=[CountDebt]

--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.


Todd said:
I have a report that prints a list of Checkbox fields. At the very bottom,
I want the report to show how many "True" values there were in the [debt]
field. I've tried putting a textbox in the 'page footer' section with
various formulas with no luck. Can anyone please help? Thank you!!!
Click to expand...
Click to expand...
 
Back
Top