I must be missing something obvious on this. I have a query where I want to calculate an average of numbers in grouped field. I am simply using the QBE grid and then Totals - and then selecting the filed, and Avg. The results are displaying like this:
AvgOfLENGTH
133
128
119.8
126.4
126.529411764705882352941
130
123.647058823529411764706
112
I just want these rounded. I would want 119.8 to be 120 and 126.4 to be 126 and 126.529411764705882352941 to be 127. How do I do this?
AvgOfLENGTH
133
128
119.8
126.4
126.529411764705882352941
130
123.647058823529411764706
112
I just want these rounded. I would want 119.8 to be 120 and 126.4 to be 126 and 126.529411764705882352941 to be 127. How do I do this?