DIV by Zero??? 1

[WB786]

I know you can use the following to mask the error:

=IIf([MeterHours]=0,"0",[TotalGallons]/[MeterHours])

But I also need it to do the same if the value in MeterHours is Null. So whether the MeterHours is Null or Zero it should put a Zero there instead.

Thank you in advance,

WB

 

[SgtJarrow]

Try (typed, not tested)

=IIf(Nz([MeterHours],0)=0,"0",[TotalGallons]/[MeterHours])


If my syntax is wrong...look at the Nz function

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
VB/Access Programmer

 

[WB786]

WORKED LIKE A CHARM!!!

THANKS!!!

WB