Report problems (sums, avgs, etc)

  • Thread starter Thread starter ChuckA
  • Start date Start date
C

ChuckA

I have created a report that pulls up the information
between the begin date and end date according to the unit
number (unique vehicle number). Now my boss wants some of
the fields in the report to show the sums of those fields
as well as avg of other fields at the end of the report
(after the last line prints). Also he has requested for
cetain fields a min and max value field to also be
displayed. I have tried everything I can think of and am
now at a total loss as to what to do. Any assistance would
be greatly appreciated.
 
This stuff is fairly basic. The first step is to make sure that you place
your summary text boxes in the Report Footer section and not the Page Footer
section. Then it's setting your control source to something like:
=Sum([Your Numeric Field])
=Avg([Your Numeric Field])
=Max([Your Numeric Field])
 
Back
Top