Summing rounded numbers

[Adam]

I can't get a correct grand total of a set of rounded
numbers. I get the number for each record in the query to
round correctly. However, I can't get a correct grand
total. Instead of totaling the rounded numbers, it only
totals the unrounded numbers. I've tried to get it to
work in both the query and the report. Can anyone point
out what I'm doing wrong?

Thanks,

Adam

 

[Allen Browne]

Sounds like you are only rounding the display of the numbers.

To create a calcuated field in your query that actually rounds the numbers,
enter something like this into the query design grid (Field row):
MyResult: Round([MyField], 2)
If you are using Access 97 or earlier, there is no built-in Round()
function, but you can grab one from:
http://www.mvps.org/access/modules/mdl0054.htm