I have a calculated avg field in a query that I need to round up to the nearest whole number. But when I use this:
It doesn't give me consistent results. For example 9.727272 rounds to 10, 72.6 rounds to 73 and 79.63636364 rounds to 80 but 57.63636364 rounds to 57. Why does this last one don't round to 58? And What's the best way to accomplish this?Code:AvgEE: Round([AvgOfSumOfee_count],0)