#ERROR in calculated field

  • Thread starter Thread starter juan
  • Start date Start date
J

juan

hi,
I have the following expression in a field:

ACP: Format([Ext]/[QOH],"0.00000") works fine but as you
know if try to divide 0/0 will get the #ERROR. Is there a
way to go around this and put a 0 instead? I try putting
Nz, but not sure if this works or maybe I put it wrong.

Please advise with any feedback.

Thanks,

Juan
 
Hello Duane,
thanks alot for your help. Seems to be working.

I really appreciate the help.

Have a good one.

Thanks again,
juan
-----Original Message-----
ACP: Format(IIf(QOH=0,0, [Ext]/[QOH]),"0.00000")

--
Duane Hookom
MS Access MVP
--

juan said:
hi,
I have the following expression in a field:

ACP: Format([Ext]/[QOH],"0.00000") works fine but as you
know if try to divide 0/0 will get the #ERROR. Is there a
way to go around this and put a 0 instead? I try putting
Nz, but not sure if this works or maybe I put it wrong.

Please advise with any feedback.

Thanks,

Juan
Click to expand...


.
Click to expand...
 
Back
Top