Suppress "#Error" result in query?

[Gregg Eckhardt]

I have a simple calculated field in a select query to
derive the common logarithm of FIELD1 as such:

A: Log([FIELD1])/Log(10)

For records where FIELD1 is null, the datasheet view
displays #Error, otherwise the result is correct.

I'd like for it to simply display nothing for records
where FIELD1 is null.

Is there a simply way to do this?

Thanks in advance for any help you can provide.

- Gregg

 

[Gina]

I hope I get this right:

A: IIf(IsNull([FIELD1]),"",Log([FIELD1])/Log(10)))