Suppressing Zeroes

[Zeroed]

I have a number of zeroes in my query and therefore my
reports are really tough to read through.

0 was set as the default value in the tables but I'm sure
there is a way to suppress them for the reports. I have
tried an IIF statement with no luck.

Any suggestions?
Thanks

 

[fredg]

I have a number of zeroes in my query and therefore my
reports are really tough to read through.

0 was set as the default value in the tables but I'm sure
there is a way to suppress them for the reports. I have
tried an IIF statement with no luck.

Any suggestions?
Thanks

In the report, set the Control's Format property to:
#;-#;""

See Access Help on
Format property + Number and Currency datatype

 

[Zeroed]

Wicked, thanks

-----Original Message-----


In the report, set the Control's Format property to:
#;-#;""

See Access Help on
Format property + Number and Currency datatype
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.