#num! Error

[Randall Roberts]

i have a formula in a report which produces the following error #num!
only when under certain circumstances

Whenever this error occurs i need the report to show 1 in place of the
error

in excel this is fairly easy to do
is there a similair way to do this in access?

Thanks for any help
Randall

 

[R. Hicks]

See the IsError() function.

RDH