Group by and AVG and then would like to round the data....

G

Gary F Shelton

I have a table with 50K records in it. I have only selected 5 columns within
it which are:
Plant CD
Plant Name
Plant Type
The trans mode
and another field which is called The # of Days between the created date and
the due date. It is this field that I have a quesion.

In my new query I want to get the group fields 1 thru 4 by group and then
field 5 will be the AVG. I clicked the summation key within the query and I
can change this field to AVG and it will do the calculation. However, when
the data is returned I would like to round the data. Can this be done?
 
J

John Spencer

Post the SQL of the query you currently have. Someone can then give you the
needed modification. You should end up with something like:

Round(Avg([YourField]},2)

If design view
Replace [YourField] with the above expression and change Avg in the totals
line to Expression



John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
 
Top