I'm having trouble getting results in the right format. I want to multiply UnitPrice by Quantity with the result in ExtendedPrice. The ExtendedPrice result winds up with one too many digits after the decimal point that causes SubTotal to be off by a cent or two. I've changed data types on all fields and I seem to be getting the best results with the text data type. However, I'm still getting three digits after the decimal in ExtendedPrice. I've tried setting the decimal point value to 2 but it there's no effect. Any suggestions?
-
-
Very strange, I have just created a query with Quantity, UnitPrice and ExtendedPrice as a calculated field, and it shows ExtendedPrice as currency with no type casting.
SELECT TblExtendedPric e.Quantity, TblExtendedPric e.UnitPrice, [quantity]*[unitprice] AS ExtendedPrice
FROM TblExtendedPric e;
In the table I have Quantity as data type Number, Long Integer and UnitPrice as data type Currency? Shouldn't need to change data types?
Comment