How do I show 0 instead of #Num! errors on my report

jess85

New member
Local time
Today, 17:13
Joined
Aug 10, 2011
Messages
1
Hi guys,

I'm new to Access report building, I have basically self taught myself and need some help with showing zero's instead of those ugly errors. #Num! and #Div/0!

The calculations from the three boxes on my report that are bringing up this error are below.

=(Sum([New Appt])/2)/(Sum([Contact]))

=Sum([Number of Sales])/(Sum([Appt1]/2)+Sum([Appt2])/2)

=(Sum([Sale/ renewal/ review])*100)/(Sum([number of sales]))

I really hope someone can help. :(
 
Last edited:
Check out the NZ function also
 

Users who are viewing this thread

Back
Top Bottom