By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,400 Members | 953 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,400 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 has no effect. Any suggestions?
Oct 9 '06 #1
Share this Question
Share on Google+
5 Replies


10K+
P: 13,264
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 has no effect. Any suggestions?
Only one post is enough for people to help you. Double posting puts some people off.
Oct 9 '06 #2

P: 6
The double post was an accident.....Oh, by the way, thanks for the help Dickweed.
Oct 9 '06 #3

P: 2
The double post was an accident.....Oh, by the way, thanks for the help Dickweed.
Oh dear, I think you've blown your chances of getting help now!
Oct 10 '06 #4

dima69
Expert 100+
P: 181
It's really quite simple - you should use Round function within your Extended price calculation:
Expand|Select|Wrap|Line Numbers
  1. =Round([Price]*[Quant],2)
And also within the total:
Expand|Select|Wrap|Line Numbers
  1. =Sum(Round([Price]*[Quant],2))
Oct 11 '06 #5

10K+
P: 13,264
The double post was an accident.....Oh, by the way, thanks for the help Dickweed.
That is not neccessary
Oct 11 '06 #6

Post your reply

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