What is the MS Access equivalent of an If(Iserror) formula in Excel?
Here is the formula I am trying in Access and I still get a #Num! error on the report.
=IIf(IsError([Margin $$]/[Net Sales]),0,[Margin $$]/[Net Sales])
How can I fix?
Thanks,
Jonbob
Here is the formula I am trying in Access and I still get a #Num! error on the report.
=IIf(IsError([Margin $$]/[Net Sales]),0,[Margin $$]/[Net Sales])
How can I fix?
Thanks,
Jonbob