Adding cells in a report

  • Thread starter Thread starter Mike
  • Start date Start date
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!
 
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])
 
Back
Top