Oct 11 2006, 12:08 PM
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.
Oct 11 2006, 01:14 PM
how about if on the query level you did an expression that was something like this
and then call up the field [blanks] instead of the field [number]
Oct 11 2006, 01:22 PM
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.
Oct 11 2006, 01:25 PM
no problem... so you got it sorted I am guessing... if so then... groovy
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here