Calculated Fields

[bstice]

I have a form with calculated fields that sometimes result in a #NUM! or #DIV/0!. Is there a formuala that I can put in the control source to cause these errors to provide a "-" value?

Something like this:

if(tb1 iserror, "-", tb1/tb2)

Thanks all

Brennan

 

[KenHigg]

iif(nz([tb2]) = 0, "-", nz([1])/[tb2])

???

 

[The_Doc_Man]

For the DIV/0 case, you could try

= if (divisor = 0, "DIV0", dividend/divisor )

For the NUM case, there is

= if( IsNumeric(x), x, "Not a number" )

Hint on the list of these... in the Expression Builder, the built-in functions come in various categories. You want to step through the Inspection category and look up each of those see exactly what you can test for.