Calculation problem

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

mattc66 via AccessMonster.com

Hi All,

I have a query that appears to be doing something funny with my calculations..


What settings in access would cause the below. I don't have the Round
statements in my formulas.

160 * .62 = 99.20 how ever in my query it is coming up as 99.00
480 * 1.27 = 609.60 coming up as 609.84
160 * 1.07 = 171.20 coming up as 171.60

Does anyone have a suggestion?

SELECT tblOrderDetails.QuoteID, tblOrderDetails.LINE_Num, tblOrderDetails.
OrderDetID, tblOrderDetails.OrderNum, tblOrderDetails.Qty, tblOrderDetails.
Item, tblOrderDetails.Description, tblOrderDetails.AvgCost, tblOrderDetails.
ListPrice, (tblOrderDetails.ListPrice*[Multiply]) AS SalePrice,
tblOrderDetails.Price, tblOrderDetails.AR_Code, [Qty]*tblOrderDetails.
ListPrice AS ExtListPrice, [Qty]*[SalePrice] AS ExtPrice, tblOrderDetails.
Group, tblOrderDetails.AR_Matrix, tblOrderDetails.Discount, tblOrderDetails.
Multiply,
FROM tblOrderDetails
ORDER BY tblOrderDetails.QuoteID, tblOrderDetails.LINE_Num;
 
mattc66 said:
Hi All,

I have a query that appears to be doing something funny with my calculations..


What settings in access would cause the below. I don't have the Round
statements in my formulas.

160 * .62 = 99.20 how ever in my query it is coming up as 99.00
480 * 1.27 = 609.60 coming up as 609.84
160 * 1.07 = 171.20 coming up as 171.60

Does anyone have a suggestion?

SELECT tblOrderDetails.QuoteID, tblOrderDetails.LINE_Num, tblOrderDetails.
OrderDetID, tblOrderDetails.OrderNum, tblOrderDetails.Qty, tblOrderDetails.
Item, tblOrderDetails.Description, tblOrderDetails.AvgCost, tblOrderDetails.
ListPrice, (tblOrderDetails.ListPrice*[Multiply]) AS SalePrice,
tblOrderDetails.Price, tblOrderDetails.AR_Code, [Qty]*tblOrderDetails.
ListPrice AS ExtListPrice, [Qty]*[SalePrice] AS ExtPrice, tblOrderDetails.
Group, tblOrderDetails.AR_Matrix, tblOrderDetails.Discount, tblOrderDetails.
Multiply,
FROM tblOrderDetails
ORDER BY tblOrderDetails.QuoteID, tblOrderDetails.LINE_Num;
Click to expand...

The results suggest you actually have [Multiply] values of
0.61875 (not .62)
1.2705 (not 1.27)
1.0725 (not 1.07)

Are you certain of the [Multiply] values in the table?
 
Back
Top