By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,991 Members | 1,911 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,991 IT Pros & Developers. It's quick & easy.

avoid zeros in report

P: n/a
jj
Hi

I have a report based on a table with some columns with numbers.

Now my problem is that when I display the columns in my report there is a
zero a lot of places, and I would rather want to display blanks instead of
zero. Can anyone tell me how to do that?

Thanks
jj
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Sat, 11 Sep 2004 18:51:35 +0200, jj wrote:
Hi

I have a report based on a table with some columns with numbers.

Now my problem is that when I display the columns in my report there is a
zero a lot of places, and I would rather want to display blanks instead of
zero. Can anyone tell me how to do that?

Thanks
jj


Depending upon how you want the positive and negative numbers
formatted, set the format property of the control to:
#;-#;
or..
#,###;-#,###;
or..
#,###.00[Black];(#,###.00)[Red];
etc.
See Access Help
Format Property + Number and Currency Datatypes
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.