Calculation not working

[slpixie]

Hi. Access 2K. I have a financial report. In the footer I have three text
boxes where I have totaled Revenues, Expenses, and Indirects that are grouped,
for the total budget field, in the detail section. I need to calculate the
overall total budget in the report footer. The three text box names are Rev,
Exp, and EID. The formula in the fourth text box =sum(Rev - Exp - EID) does
not work. I need to subtract Exp and EID from Rev. Please help!!!!

 

[Marshall Barton]

Hi. Access 2K. I have a financial report. In the footer I have three text
boxes where I have totaled Revenues, Expenses, and Indirects that are grouped,
for the total budget field, in the detail section. I need to calculate the
overall total budget in the report footer. The three text box names are Rev,
Exp, and EID. The formula in the fourth text box =sum(Rev - Exp - EID) does
not work. I need to subtract Exp and EID from Rev.

The aggregate dunctions only operate on fields in the
report's record source table/query. This means that you
need to use the field names instead of the text box names.

 

[slpixie]

The aggregate dunctions only operate on fields in the
report's record source table/query. This means that you
need to use the field names instead of the text box names.

Thanks for the response. I added Exp and EID in another text box and then in
yet another subtracted it from Rev and got the answer I needed.