Using INT()

[DS]

Am I doing this correctly? This is for Tax Reasons.
Here is my example;
Int((NumberToRound * 100) + 0.5) / 100

Her is my Code
Me.TxtNoneTax = Int(Nz(DSum("(CDQuantity*CDFinalPrice)*CDTaxRate",
"tblCheckDetailsTMP", "CDCheckID = " & Forms!Form2!TxtCheckID & " AND
CDDiscountDP = 0"), 0) * 100 + 0.5) / 100

Thanks
DS

 

[DS]

I guess I do want the basic rounding, the problem with the round function is
that it isn't great when it comes to taxes, this seems to be working fine
for now. Thanks
DS

 

[DS]

Hi Marsh,
What did you mean Round To Negative? What part of the code does that? And
if I wanted to Rount To Positive how would I do that?
Thanks, I appreciate the input.
DS

 

[DS]

Thanks Marsh,
After looking into it I've decided to use the Round() set to 2 . There's an
article about it by Allen Browne, it's called Bankers Rounding. So if it's
good enough for a bank, I guess it will do for me.
Thanks
DS