Is there a way to make zero amounts appear blank in a report? I must do this without giving up the decimal places = 2.
thanks if someone has this, I cannot find it.
Jay

how about if on the query level you did an expression that was something like this

blanks: IIf([number]=0,Null,[number])


and then call up the field [blanks] instead of the field [number]

Thanks,
Actually, to keep the #,### format and number of decimal places, I had to loop through each control and check if zero then set decimal places to "0" - only this way could I get blanks withoug giving up on the number of decimal places property.

no problem... so you got it sorted I am guessing... if so then... groovy