% In Query

[fenhow]

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

 

[pbaldy]

Untested, but try

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

 

[fenhow]

Paul, You always come through.

Perfect! Thanks a million.

Cheers,

Fen

 

[pbaldy]

No problem Fen.