Rounding Issue

  • Thread starter Thread starter mattc66 via AccessMonster.com
  • Start date Start date
M

mattc66 via AccessMonster.com

Hi All,

I am strugling with a rounding issue in a query.

Example:
List price = $1365.00
Mulitipler = .425
Sale Price = 580.125
x 5 units = 2900.625

However I need the sale price to be: 580.13 x 5 = 2900.65

i have set the SalePrice: Round(([ListPrice]*[Multiplier]),3) and the result
displays 580.13 but when I do the same Round(([SalePrice]*[Qty]),3) = 2900.63.
Do I need to perform 2 seperate Queries?

Matt
 
mattc66,
However I need the sale price to be: 580.13 x 5 = 2900.65
Click to expand...

I think you just answered your own question.

round 580.125 to 2 places first, then multiply by 5.

Round([SalePrice],2)*[Qty].

You mention that you take List Price X Multiplier, then round to 3 places,
but it shows as 580.13. What displays and what the actuall value is, are 2
different things. Check the formatting for that column. It might be set to
only show 2 decimal places. If that is the case, then it will show 580.13,
but its value will still be 580.125 (the value will be used in calculations,
not what is displayed).

HTH,

Conan





mattc66 via AccessMonster.com said:
Hi All,

I am strugling with a rounding issue in a query.

Example:
List price = $1365.00
Mulitipler = .425
Sale Price = 580.125
x 5 units = 2900.625

However I need the sale price to be: 580.13 x 5 = 2900.65

i have set the SalePrice: Round(([ListPrice]*[Multiplier]),3) and the
result
displays 580.13 but when I do the same Round(([SalePrice]*[Qty]),3) =
2900.63.
Do I need to perform 2 seperate Queries?

Matt

--
Matt Campbell
mattc (at) saunatec [dot] com

Message posted via AccessMonster.com
Click to expand...
 
It will also be wise for you to do a search for the term "Banker's
Rounding" in this forum.

Access DOES NOT ROUND
 
I wouldn't have blamed you. Somehow I hit the tab and it took me to
the send button and when I hit enter that sent it off before I had
finished.

Ron
 
Back
Top