Averages on Reports

[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

 

[Marshall Barton]

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

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

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