ROUNDING PROBLEM IN ACCESS 2002

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm having trouble with Rounding in Access 2002...

Here's my formula:
Extended Cost:([Mileage]*0.345)+[Cost]

When I run that formula through my query, with Cost = $25 and Mileage = 25,
my Extended Cost displays as $33.63, which is correct. However, when I click
on that, the screen removes the $ and displays 33.625 ---

So, I modify the formula to include rounding:
Extended Cost:Round(([Mileage]*0.345)+[Cost],2)

Now, my Extended Cost displays as $33.62, which is NOT correct! When I
click on that figure, the screen removes the $, but RE-displays 33.62 ---

HOW do I get this ROUNDING formula to work? I want the net result to
display AND store 33.63 ---

Any help from anyone out there would be greatly appreciated.
 
Larry

What datatype are these fields? Any chance you've defined one/more as
Single or Double?

Good luck

Jeff Boyce
<Access MVP>
 
Jeff,

Cost = Currency
Mileage = Number

Problem resolved by using small bias (0.001) to override Banker's Rounding...

I appreciate the response, though...

Larry

Jeff Boyce said:
Larry

What datatype are these fields? Any chance you've defined one/more as
Single or Double?

Good luck

Jeff Boyce
<Access MVP>

Larry J. said:
I'm having trouble with Rounding in Access 2002...

Here's my formula:
Extended Cost:([Mileage]*0.345)+[Cost]

When I run that formula through my query, with Cost = $25 and Mileage = 25,
my Extended Cost displays as $33.63, which is correct. However, when I click
on that, the screen removes the $ and displays 33.625 ---

So, I modify the formula to include rounding:
Extended Cost:Round(([Mileage]*0.345)+[Cost],2)

Now, my Extended Cost displays as $33.62, which is NOT correct! When I
click on that figure, the screen removes the $, but RE-displays 33.62 ---

HOW do I get this ROUNDING formula to work? I want the net result to
display AND store 33.63 ---

Any help from anyone out there would be greatly appreciated.
Click to expand...
Click to expand...
 
Back
Top