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.
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: