Question Conditional formatting percentage result.

[binbin]

Hi everyone!

This is driving me nuts for hours now... I was trying to look for a solution here, but it seems to relate to a different cases or I'm using the wrong words to search...

Anyway, I think this is a very simple problem, yet I'm unable to fix it. I have a subform based on a query. In that query, I have calculated values for price+tax and another price+discount+tax.

Now I have a conditional formatting that if the gross total is not equal to amount due, the amount due box will turn red. However even if they are equal visually, it still turns red. Ex. The gross total is 336.00 and the amount due is 336.00 also, so it should NOT turn red, but it does. When I click on the amount due control, the value turns into 335.999999195337. So they are really not equal in this sense, but visually (meaning when I do not click on the control) they are equal at 336.00.

How do I tell access not to make 336.00 into 335.999999195337. It's annoying....

Thanks!

 

[John Big Booty]

You could use the Field Value Is Between Condition and and give yourself a little leeway.

 

[binbin]

Hi again,

If you're wondering, I did find the Round Function already, but is there another way not to use that? Because I don't want to round the gross amount also...

 

[binbin]

You could use the Field Value Is Between Condition and and give yourself a little leeway.

Hi, that is a very good alternative, not that precise, but then again, I just want to warn the user that a discount has been applied, so I guess this will definitely be applicable.

Thanks!