MS Access and FileMaker...

Simlpe math not adding up on report

Please support our MS Access and FileMaker Pro advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: Apr 2008

Posts: 8

Reputation: MarcusMaximus is an unknown quantity at this point

Solved Threads: 0

MarcusMaximus MarcusMaximus is offline

Offline

Newbie Poster

Simlpe math not adding up on report

Jun 24th, 2009

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

•

Join Date: Jan 2009

Posts: 1,321

Reputation: almostbob has a spectacular aura about

Solved Threads: 161

almostbob

Offline

Nearly a Posting Virtuoso

Re: Simlpe math not adding up on report

Jun 24th, 2009

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.

Failure is not an option It's included free
If at first you dont succeed, join the club
Of course its always in the last place you look, you dont keep looking after you find it

Please mark solved problems, solved