Averages on Reports

  • Thread starter Thread starter Michael Comtois
  • Start date Start date
M

Michael Comtois

Is there a way to average numbers in a certain field
based on the value in another field? For instance, if
the record is type D, select the values from the
turnaround field and average all the values. I would
like to do this all on the report if possible. Help
would be great! I am using Access 2002.

Mike
 
Michael said:
Is there a way to average numbers in a certain field
based on the value in another field? For instance, if
the record is type D, select the values from the
turnaround field and average all the values. I would
like to do this all on the report if possible. Access 2002
Click to expand...

Try a text box in a group footer or the report footer with
an expression like:

=Avg(IIf([type] = "D", [turnaround], Null))
 
Back
Top