Sum rounding problem

[Tomm]

When using the SUM formula against a columm of numbers formatted as currency, the result of the sum is not correct. The query is doing some sort of rounding which results in the calculation being skewed by the extra decimal places in the numbers being summed. In MSExcel there is a feature under tools/options/calculation to select "precision as displayed" which corrects this same problem in MSExcel. My question is, how is this "precision as displayed" characteristic applied to my MSAccess report so the sum formula produces the desired result?

Thanks folks!

 

[WayneRyan]

Tomm,

How about, in the query for your report:

NewField: Round([OldField], 2)

Wayne

 

[mohsinhq]

does this method work in access 97? because i get an error:

'Undefined function 'round' in expression'

any ideaS?