 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / June 2005truncating values in sum on report
Hi, I have a fairly simple report which is providing odd results. I have a report with 2 levels of groups and a qualtity - contribution. I would like to total contribution in the footer of both groups. I am using the formula =sum([contribution]). The fields in the data base are formatted currency and the fields in the report are formated currency. The result I get is the sum of the integer portion of the individual contributions, not the actual sum. Any ideas? Cindy Set the FORMAT property of the total box to CURRENCY -- Allan Murphy Email: allanmurphy@unwired.com.au > Hi, > [quoted text clipped - 5 lines] > of the integer portion of the individual contributions, not the actual sum. > Any ideas? Yes, I have all the fields in the query and the report set as currency - including the totals which are providing the incorrect result. Cindy > Cindy > [quoted text clipped - 18 lines] > sum. > > Any ideas? >Hi, > [quoted text clipped - 5 lines] >of the integer portion of the individual contributions, not the actual sum. >Any ideas? The Currency *FORMAT* merely controls how the information is displayed, not what's stored. I'm guessing that the datatype of this field in the underlying table is a Number, Long Integer - the default size of a Number field. Long Integers are, by definition, whole numbers which do not support fractions. A Currency *datatype* - it's one of the selections along with Number, Text, Date/Time etc. in table design mode - will be better; it is a huge scaled integer with exactly four decimal places and no roundoff error. John W. Vinson[MVP] Thanks! That was the problem. I am getting the data from a source on a 3000 so I used the val function and poof - correct sums. Thanks for responding to my post - it really helped! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.