Wow that works great. Thanks

how about % type numbers, what is the correct format?

"Douglas J. Steele" wrote:

You could try using the Format property of the text box in which the
calculation is being displayed. Formats for numeric fields can have up to
four sections defined, with each section separated by semi-colons. The first
section is the format for positive numbers, the second section is the format
for negative numbers, the third section is the format for zero values, and
the fourth section is the format for Null values.

You could use something like

#.0;(#.0);"-";"-"


--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Hadi" wrote in message
...
Hello Experts,

I have a report that based on a query. The query adds up my monthly hours
for the people that work on the project and the report displays the
result.
my formula in the query to calculate total forJanuary for example is
07Jan:
Nz([07Jan_1])+Nz([07Jan_2])+Nz([07Jan_3])+Nz([07Jan_4]). So all I do is
add
the field 07Jan into my report. The problem am having is I like to replace
all the 0.00 totals with "-". I try to do IIF(Nz([07Jan]=0,"-",Nz([07Jan])
but I get an #Error in the repot. The only way I got to work is by using
a
text box and if I repeat the whole formula in the report as well by
saying:
IIF(Nz([07Jan_1])+Nz([07Jan_2])+Nz([07Jan_3])+Nz([07Jan_4])=0,"-",Nz([07Jan_1])+Nz([07Jan_2])+Nz([07Jan_3])+Nz([07Jan_4]))
but I am defeating the point of using the query to calcuate my totals. I
am
sure there is a simple way to do it but can't get there

Help is always appreciated

Hadi