Access Data base Report question

[dreadnaught]

I am running a report with a calculation. At some points in time the report divides by zero. This causes and #Error to appear in the report. I am trying to figure out how to get ride of the error. I tried an if statement but it did not work. With the error in the report Access will not allow me to download the report to an excel file which is my ultimate goal. Can anyone help?

 

[finglem]

dreadnaught

I don't know about access too much but in excel you can use
IF(ISERROR(whatever the calculation is),0,whatever the calculation is)
maybe there is something like that in access

 

[Pampers]

Hi Dreadnaught,
Use the Nz-function (no zero's) in your calculated control, like i did below

=Nz([pd_total in $])+Nz([wharf total in $])