943,791 Members | Top Members by Rank

Web Development > Databases > MS Access and FileMaker Pro > Simlpe math not adding up on report
Ad:
Permalink
Jun 24th, 2009
0

Simlpe math not adding up on report

Expand Post »
i have an access report with two sub reports. A text box in the main report adds 2 values in both sub reports together.

One value is 10.22 and the other is 13.08 which should amount to 23.30 but the value is coming out at 23.29 which is off by one cent.

i have all text boxes set as currency and decimal places set to auto, i have tried setting the decimal places to 3 and it didn't work and also tried round([txtbox1],3) to no avail.

Any help greatly appreciated
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
MarcusMaximus is offline Offline
19 posts
since Apr 2008
Permalink
Jun 24th, 2009
0

Re: Simlpe math not adding up on report

round the sub totals to two(2) decimal places
the totals are 10.216 and 13.077 (or similar) displayed to two decimal places

round(10.216+13.076,2) = 23.29
round(10.216,2) + round(13.077,2) = 23.30
Last edited by almostbob; Jun 24th, 2009 at 5:40 pm.
Reputation Points: 562
Solved Threads: 368
Posting Maven
almostbob is offline Offline
2,970 posts
since Jan 2009
Permalink
Jun 25th, 2009
0

Re: Simlpe math not adding up on report

Thanks sorted the proble.
Is there anyway to make the thread as solved
Reputation Points: 10
Solved Threads: 0
Newbie Poster
MarcusMaximus is offline Offline
19 posts
since Apr 2008
Permalink
Jun 25th, 2009
0

Re: Simlpe math not adding up on report

Found it
Reputation Points: 10
Solved Threads: 0
Newbie Poster
MarcusMaximus is offline Offline
19 posts
since Apr 2008

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in MS Access and FileMaker Pro Forum Timeline: Logon Error in Database
Next Thread in MS Access and FileMaker Pro Forum Timeline: Update Multiple Tables with a Single Form





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC