averaging in a query

[JSchade]

I am using a query to average but I would like this to round off to whole numbers. How do I get it to do that?

 

[boblarson]

How are you doing the Average in the query? Are you using the

MyNewFieldNameHere: Avg([OriginalFieldNameHere])

or doing it in a Grouping query?

If in the first you can simply use:

MyNewFieldNameHere:CLng(Avg([OriginalFieldNameHere]))