Try...
= Format([YourAvg], "#")
19.5 should display as 20 (rounding up from .5 or greater)
23.1678993 should display as 23 (rounding down from .5 or less)
or... if you need numeric...
= Val( Format([YourAvg], "#"))
--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html
"Find a job that you love... and you'll never work a day in your life."
"Summing multiple fields on a form"
t.com wrote in message
...
I created a summary report using the report wizard and grouped by date and
selected avg.
The report works fine except I would the numbers to be rounded. For
example:
The average for January shows 19.5, however I would like it displayed as
20.
If February is 23.1678993, I would like it displayed as 23.
Can someone help me with this? Thx