Format a Query Field

S

Susan R

I am trying to format a query field to only display 2 digits to the right of
the decimal. The field is an expression that I built as =Round((IIF
Statement),2). This rounds the numerical results but if the field the
statement is dependent upon is null, I get a #Error. Can someone tell me
what I am doing wrong?
 
O

Ofer

try that
select format(nz(MyFieldName,0),"#.##"),b,c from ....

use the nz function before your field ,so it will return a 0 instead of null
 
Top