Conditional text field Total

  • Thread starter leahf via AccessMonster.com
  • Start date
L

leahf via AccessMonster.com

Hi,

In the detail section of a report I have a text box that based on a condition,
it will be either a 0 or a 1.

I want to total the control at the end of the report. I did this in another
report a couple of years ago but it is not working now.

In the previous report, the ControlSource of the total is =
[TextBoxNameFromDetailSection] and it sums correctly.

What am I doing wrong??

Thanks.
Leah
 
L

leahf via AccessMonster.com

Thanks but I see what was missing - "running sum over all"

Leah

Hi,

In the detail section of a report I have a text box that based on a condition,
it will be either a 0 or a 1.

I want to total the control at the end of the report. I did this in another
report a couple of years ago but it is not working now.

In the previous report, the ControlSource of the total is =
[TextBoxNameFromDetailSection] and it sums correctly.

What am I doing wrong??

Thanks.
Leah
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

A03 - count in report footer gives me #Error? 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Access 2002 change report header text 0
Report Grand Total Miscalculating Overtime 5
One and One-half Columns and Grand Total on Same Page (?) 5
Microsoft Project 2016 Monthly Cost Report/ Table Creation Help 0
Group summation not working 3
Cross Tab Report Vs Dynamic coulmns 0

Top