Subtraction in reports (1 Viewer)

[moleary]

How can I do subtraction in my report, I have two columns one for requested hours and another for approved hours and I have totaled these columns now I would like to see the difference in hours?

 

[Coolguy]

try thhis
=[requestedhours]-[approvedhours] on a text box

 

[moleary]

I did that and it gave me #error, I put a text box and with the expression builder I put approved hours-requested hours?

 

[Rich]

Which part of the report are you putting the calculation in?

 

[Pat Hartman]

Check the control name of the textbox. It cannot be the same as the name of one of the columns used in the form's recordsource. When you use a wizard to build a form, it usually names the controls with the same name as the recordsource column that is bound to them. If you changed one of these wizard built controls to do the calculation, you'll need to change the control name.

Normally having the control name the same as the recordsource column name it is bound to is not a problem. However, if you do any calculations, Access has no way of knowing whether you are refering to the control or the recordsource column and that generates the #error.