Hi,

I am using this to calculate a % in my query.

Expr1: Format([SumOfNMA]/[Surface_Acres],"Percent")

It works great execpt where there are zeros, it shows error. Is there a work around for this?

Thanks.

Fen How

Untested, but try

IIf([Surface_Acres] = 0, 0, Format([SumOfNMA]/[Surface_Acres],"Percent"))

Paul, You always come through.

Perfect! Thanks a million.

Cheers,

Fen

No problem Fen.