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

Decimals in Access Report

P: 1
I have a problem with the decimals in a report I created in Access Database. In a table I have two fields. One is the "price" the second one is "quantity". When I develop a report I would like to have another field which is a result of Price * Quantity with a 2 decimals on the result. Example: 914,539.00 * $50.21, the result must be $45,919,003.19, however the report will shows always a wrong result of $45,919,002.35. I already tried to change the format in both places (table and report) but the wrong result is always showing up.

Could you please try to help me on this? I would very much appreciate.


Mario Pais
Jun 11 '07 #1
Share this Question
Share on Google+
3 Replies

Expert Mod 10K+
P: 14,534
I am moving this question to the Access forum.

Jun 11 '07 #2

Expert Mod 10K+
P: 14,534
Try this ...

Set quantity to Long Integer. Set Price to Currency

Now set new field to

Format(Price * Quantity, "Currency")
Jun 11 '07 #3

Expert 100+
P: 159
Is it possible that the price contains some digits beyond the second place. Even thought the data type in the table is set to currency you can still save data with more than two decimal places it just shows only two. This could happen if the price was calculated by multiplying by a markup or dividing a pallette price to get the each and not rounding the product before saving it to the table.
You may be seeing 50.21 but are actually multiplying by 50.20999908.
Jun 11 '07 #4

Post your reply

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