446,400 Members | 953 Online
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
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

 Expert 100+ P: 181 It's really quite simple - you should use Round function within your Extended price calculation: Expand|Select|Wrap|Line Numbers =Round([Price]*[Quant],2) And also within the total: Expand|Select|Wrap|Line Numbers =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