Substituting Values in a Report for Other Values

[sandybam]

I hope I can explain this properly...

I have a calculation in a query that produces the total calls per hour for our employees. If an employee did not have any calls Access tells me that the Total Calls Per Hour value equals #Error instead of "0".

I'm not sure if I can program Access the same way as Excel by saying if Total Calls equals "0" then don't even perform the calculation just place a "0" in the Total Calls per Hour field. Otherwise, is there a way to tell the report if you see "#Error" place a "0" in that field instead?

Thank you!
Sandy

 

[MARKNLA2]

Try the iif(isnull(....)) function.