Rounding Issue

[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

 

[Conan Kelly]

mattc66,

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

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

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

 

[Ron2006]

It will also be wise for you to do a search for the term "Banker's
Rounding" in this forum.

Access DOES NOT ROUND

 

[Ron2006]

Now for the rest of the sentence.


Access DOES NOT Round the same way as Xcel.

Ron

 

[Tom Lake]

Now for the rest of the sentence.


Access DOES NOT Round the same way as Xcel.

Darn! I was just about to excoriate you!.

Tom Lake

 

[Ron2006]

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