Calculation Problem In Query

[aamer]

Am not getting the desired result from a query.


Qty X GSTPrc = PrcCr
If the Qty = 15780 & GSTPrc = 4.50 The result should be 71415

whereas the query is calculating 15780 x 4.5001 and the result is 71416.59

On the query I tried to use the Format "Fixed & Decimal Places to limit to 2 but not successful getting the desired result.

Transaction Description	Qty	Price	Sales Tax	GSTPrc	PrcCR		Required Result
Cullet (Green)	15,870.00	Rs. 3.85	17.00%	4.50	71416.59		71415.00
Cullet (Green)	10,230.00	Rs. 3.85	17.00%	4.50	46036.02		46035.00
Cullet (Green)	11,650.00	Rs. 3.85	17.00%	4.50	52426.17		52425.00
Cullet (Green)	13,100.00	Rs. 3.85	17.00%	4.50	58951.31		58950.00
Cullet (Green)	16,310.00	Rs. 3.85	17.00%	4.50	73396.63		73395.00
Cullet (Green)	11,040.00	Rs. 3.85	17.00%	4.50	49681.10		49680.00
Cullet (Green)	10,860.00	Rs. 3.85	17.00%	4.50	48871.09		48870.00
Cullet (Green)	14,680.00	Rs. 3.85	17.00%	4.50	66061.47		66060.00
Cullet (Green)	15,010.00	Rs. 3.85	17.00%	4.50	67546.50		67545.00
Cullet (Green)	14,050.00	Rs. 3.85	17.00%	4.50	63226.41		63225.00
Cullet (Green)	25,720.00	Rs. 3.85	17.00%	4.50	115742.57		115740.00
Cullet (Green)	14,000.00	Rs. 3.85	17.00%	4.50	63001.40		63000.00
Cullet (Green)	11,050.00	Rs. 3.85	17.00%	4.50	49726.11		49725.00
Cullet (Green)	14,650.00	Rs. 3.85	17.00%	4.50	65926.47		65925.00
Cullet (Green)	13,680.00	Rs. 3.85	17.00%	4.50	61561.37		61560.00
Cullet (Green)	2,020.00	Rs. 3.85	17.00%	4.50	9090.20		9090.00
Cullet (Green)	10,740.00	Rs. 3.85	17.00%	4.50	48331.07		48330.00
Cullet (Green)	15,920.00	Rs. 3.85	17.00%	4.50	71641.59		71640.00
Cullet (Green)	11,570.00	Rs. 3.85	17.00%	4.50	52066.16		52065.00

Querry Used:

SELECT Sales.[Transaction Description], Sales.Odered AS Qty, Sales.Price, Sales.[Sales Tax], ([Sales Tax]*[Price])+[Price] AS GSTPrc, [GSTPrc]*[Odered] AS PrcCR
FROM Company INNER JOIN Sales ON Company.CoId = Sales.CoId
WHERE (((Sales.[Transaction Description])="Cullet (Green)"));

[ssanfu]

It has to do with rounding.
([Sales Tax]*[Price])+[Price] = 4.5045
Round(([Sales Tax]*[Price]),2)+[price] = 4.50

Try this

SELECT Sales.[Transaction Description], Sales.Odered AS Qty, Sales.Price, Sales.[Sales Tax], Round(([Sales Tax]*[Price]),2)+[Price] AS GSTPrc, [GSTPrc]*[Odered] AS PrcCR
FROM Company INNER JOIN Sales ON Company.CoId = Sales.CoId
WHERE (((Sales.[Transaction Description])="Cullet (Green)"));

[aamer]

Thx it worked

[ssanfu]

Wonderful.....