Help on Price not rounding up correctly

[KenshiroUK]

Hi all I seem to be having some trouble with my unit price. Its not round up correctly.

I currently have this :

Extended Price: CCur(Nz([Quantity]+[QuantityToFollow],0)*[UnitPrice]*(1-[Discount])) which comes to £45.74, but the actually price should be £45.72. Its some how rounding up. I think. My current unit price is £7.62 however Access seems to think it is £7.6241. Anyway around this?

 

[pr2-eugin]

Rounding in Access is a real pain, specially when dealing with financial business, where every penny counts.. Allen Browne describes in detail the problems with Rounding and ways to deal with it.. Have a look at his explanation of Rounding in Access.. Should help you..