Conditional formatting not working

[Guest]

I have a text box that has a running sum of totals set up like this
=nz(Sum([Shop Hrs]))

Under the conditional format I have it set up that if the field value
is less than 3000 then format the background yellow
is in between 3001 through 3500 then format the background green
is greater than 3500 then format the background red

When I run my report the formats are working some of the time. They all
have colors, just not the right ones. Some field values that are onl 884 are
red.

Any thoughts or suggestions are appreciated. Thanks in advance.

 

[Allen Browne]

Sounds like Access is not understanding the values as numbers.

Try:
=Nz(Sum([Shop Hrs]), 0)
and set the Format property of the text box to:
General Number
or similar.

If that doesn't work, you could try typecasting. More info:
Calculated fields misinterpreted
at:
http://allenbrowne.com/ser-45.html

 

[Guest]

Thank you for the reply. That did not work though. Everything is set as you
suggested. I will try the link you recommended.

Sounds like Access is not understanding the values as numbers.

Try:
=Nz(Sum([Shop Hrs]), 0)
and set the Format property of the text box to:
General Number
or similar.

If that doesn't work, you could try typecasting. More info:
Calculated fields misinterpreted
at:
http://allenbrowne.com/ser-45.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I have a text box that has a running sum of totals set up like this
=nz(Sum([Shop Hrs]))

Under the conditional format I have it set up that if the field value
is less than 3000 then format the background yellow
is in between 3001 through 3500 then format the background green
is greater than 3500 then format the background red

When I run my report the formats are working some of the time. They all
have colors, just not the right ones. Some field values that are onl 884
are
red.

Any thoughts or suggestions are appreciated. Thanks in advance.