Using INT()

  • Thread starter Thread starter DS
  • Start date Start date
D

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
 
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
 
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
 
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
 
Back
Top