Adding cells in a report

M

Mike

Hi!
I have a report with a column that totals three different
cell values from the control source table. The report set
up f ormat is as follows

"Supplies" "Wages" "Contracts" "Total Expenses"

My formula for "Total Expenses" is : =[Wages] +
[Contracts]+ [Supplies]

However some of the cells (wages, supplies, and
contracts) are blank.

If one is blank, "Total Expneses" won't calc, even if
there are values in the other two.

Help!
 
F

fredg

Hi!
I have a report with a column that totals three different
cell values from the control source table. The report set
up f ormat is as follows

"Supplies" "Wages" "Contracts" "Total Expenses"

My formula for "Total Expenses" is : =[Wages] +
[Contracts]+ [Supplies]

However some of the cells (wages, supplies, and
contracts) are blank.

If one is blank, "Total Expneses" won't calc, even if
there are values in the other two.

Help!
Click to expand...

Look up the Nz() function in Access Help.
=Nz([Wages]) +Nz([Contracts])+ Nz([Supplies])
 
Top