getting an average on the "Count" in a report summary

[Justin]

I have a report where the data is grouped on "Date by Month". In the
footer, there is a summary that shows the number of records for the
month. There is also a sum for the total miles. I would like to get an
average of Miles per record for the month. I hope I have explained
what I would like to do sufficiently.

TIA for any help given.

Justin

 

[Marshall Barton]

I have a report where the data is grouped on "Date by Month". In the
footer, there is a summary that shows the number of records for the
month. There is also a sum for the total miles. I would like to get an
average of Miles per record for the month.

I believe the average could be calulated with the
expression:

=[the sum text box] / [the count text box]

 

[Justin]

I have a report where the data is grouped on "Date by Month". In the
footer, there is a summary that shows the number of records for the
month. There is also a sum for the total miles. I would like to get an
average of Miles per record for the month.

I believe the average could be calulated with the
expression:

        =[the sum text box] / [the count text box]

Thanks. Worked like a charm.

Justin