formatting

[aftershokk]

03 Sq Inch: IIf(IsError(([03 Pg%]*71.25)),"",(([03 Pg%]*71.25)))

Access will not let the output be formatted to two decimal places.
any thoughts?
thanks

 

[Jon K]

"" is not numeric. Try this:-

03 Sq Inch: IIf(IsError(([03 Pg%]*71.25)),Null,(([03 Pg%]*71.25)))

 

[aftershokk]

thanks so much

worked great!