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

  • Thread starter Thread starter Gary F Shelton
  • Start date Start date
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?
 
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
 
Back
Top