calculating a discount

[SAC]

I have a price of $280.25.

I want to calulate a discounted price of 10%.

I run a query showing price *.1 and then discountedprice of price-discount.

The discount shows as $28.03
The discounted price shows as $252.23
Should be $252.22

How can I get it show the penny is right?

Thanks.

 

[Allen Browne]

Round the calculated field in your query, i.e.:
Round([price] * .1, 2)