ROUND Function and Sums

  • Thread starter Thread starter el zorro
  • Start date Start date
E

el zorro

I have a report that adds a column of numbers that have all been rounded by
the ROUND function. The Sum in the report is off a bit from adding the
numbers as they are presented. Does the ROUND function only change the view
of the number, but leave the actual, original underlying number? If so, can I
do a sum that adds the rounded values (not the actual values) so that a
person reading the report will see that they they all add up? Or, is there a
way to round and then truncate the numbers that are being added to remove the
underlying decimal places? Thanks!
 
It should sum correctly if you:

a) Use the Round() function in the Field row in query design, to round to
the correct number of places.

b) Use that query as the RecordSource of your report.

c) Sum the rounded query field in the Report Footer section.
 
Thanks for your input, Allen-- I use the ROUND function in the user forms
that generate the data in question, and I couldn't figure out how there could
be extra "hidden" decimal places in the report data field. MYSTERY SOLVED:
Unbeknownst to me, someone from our Tech Services department circumvented the
forms and directly placed unrounded data in the tables. The extra places were
not visible on the report, but when I reformatted the report field from
currency to general number and ran it, there they were!
 
Back
Top