An easy one

[rschultz]

This should be an easy one (famous last words) in the Detail section of my report I have =[NWT]/2000 in the ControlSource of a text box but I get #Error. Then I tried =Sum([NWT]/2000) but then all the answers are the same number. The first formula works in the form okay but not in the Report. What am I doing wrong?

 

[Carol]

If you are trying to sum, put =Sum([NWT]/2000) in the footer section of the report.

 

[rschultz]

no, I'm just trying to get the amount in the NWT field divided by 2000 in the Detail band of the report so if they need to they can see th individual amounts. Then in the footer I will have =Sum([NWT]/2000).

 

[Old Gnome]

I was trying something similar, but the only way I could get it to work was to add another field that calculated the number the way I wanted it displayed (in your example, that would be NWT_Divided_by_2000 or some such), then use that field on the report.

If you find another solution, I would love to hear about it.

oldgnome

 

[Rich]

Add a hidden text box with the same formula set running sum to over all. Add another text box to the footer set its control source to =TheName of the text box with the running sum.
HTH

 

[rschultz]

Pat: You were right, I changed the name of the textbox to txtNWT and then it worked.
Thanks

Old Gnome: This works - it seems if the textbox is the same name as the field Access thinks the textbox is refering to itself and it gets confused.