By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,162 Members | 1,018 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,162 IT Pros & Developers. It's quick & easy.

Calculation Problems in Access 2003

P: 6
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?
Oct 9 '06 #1
Share this Question
Share on Google+
1 Reply


100+
P: 143
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 TblExtendedPrice.Quantity, TblExtendedPrice.UnitPrice, [quantity]*[unitprice] AS ExtendedPrice
FROM TblExtendedPrice;

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?
Oct 10 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.