Check for #Error

[Neil]

1/0 = #Error

How do I check for this and represent it as 0 instead of #Error?

I tried IIf(IsError([Value1]/[Value2]),0,[Value1]/[Value2) and that did not
work.

As always, thanks so much in advance for the valuable suggestions. Thanks
You!

 

[Jerry Whittle]

You can trap the error or trap what causes the error. I would look for the
cause.

IIf([Value2]=0,0,[Value1]/[Value2)

 

[Neil]

Thanks for the tip. I added a criteria for only reporting [Value2]>0. Was
hoping there was a neat trick for testing #Error.

Thanks again!

You can trap the error or trap what causes the error. I would look for the
cause.

IIf([Value2]=0,0,[Value1]/[Value2)
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

1/0 = #Error

How do I check for this and represent it as 0 instead of #Error?

I tried IIf(IsError([Value1]/[Value2]),0,[Value1]/[Value2) and that did not
work.

As always, thanks so much in advance for the valuable suggestions. Thanks
You!

 

[aaron.kempf]

SQL Server has 'try-catch' _IN_ SQL syntax.

-Aaron

Thanks for the tip.  I added a criteria for only reporting [Value2]>0.  Was
hoping there was  a neat trick for testing #Error.

Thanks again!

You can trap the error or trap what causes the error. I would look for the
cause.

IIf([Value2]=0,0,[Value1]/[Value2)

1/0 = #Error
How do I check for this and represent it as 0 instead of #Error?
I tried IIf(IsError([Value1]/[Value2]),0,[Value1]/[Value2) and that did not
work.
As always, thanks so much in advance for the valuable suggestions.  Thanks
You!- Hide quoted text -

- Show quoted text -