Let me just start with a :banghead:
I'm trying to get a query to perform a calculation and round the results.
The fields that I am running the calculation and am trying to round are Data Type Number, properties Field size Single and decimal places Auto.
I have tried the built in function described in Allen Browne's site to no avail.
http://allenbrowne.com/round.html
I have tried rounding the individual fields and then adding result.
I have also tried rounding the result (as attached).
Any thoughts?
I'm trying to get a query to perform a calculation and round the results.
The fields that I am running the calculation and am trying to round are Data Type Number, properties Field size Single and decimal places Auto.
I have tried the built in function described in Allen Browne's site to no avail.
http://allenbrowne.com/round.html
I have tried rounding the individual fields and then adding result.
I have also tried rounding the result (as attached).
Any thoughts?