Replace #Error

[bollie]

I have a query where I make a calculation. In some cases this calculation results in a division by zero. The field will then show #Fout (#Error in english?). I want to replace this message with something else, like a dash for example.

Can someone tell me how?

Thanks.

 

[peterlee516]

Me too!

I'm also looking for the solution to that problem. Any luck?

 

[boblarson]

Make a new field in your query with:

MYNewFieldName:IIf([YourDivisorField]=0,"-",[YourFieldToDivide]/[YourDivisorField])

 

[peterlee516]

That worked perfectly! Thank you Bob!

 

[boblarson]

Glad we could help