Averages in reports

  • Thread starter Thread starter lulonde
  • Start date Start date
L

lulonde

Guest
How does one calculate the average of a group of records in a report or the entire records in a report
 
lulonde said:
How does one calculate the average of a group of records in a report or the entire records in a report

if you want to calculate the average of a group of records then in the group footer create a text box and in the control source use the expression builder.

use a formula like: =AVG([yourTextBox])

if you want to average the entire report, then put the textbox into the report footer. If all else fails look it up in access Help, it's pretty useful in there :)
 

Users who are viewing this thread

Back
Top Bottom