Average . . . I'm stumped

  • Thread starter Thread starter BB
  • Start date Start date
B

BB

OK, the criteria is a specific route (bus business) which
will be listed for a set of dates. So I have 33 lines of
information (one for each date). I have a total in my
last field, but I need an average of all of those totals
for all of those dates. Now, I'm transferring to excel
to get the average of the totals. I know there's a
better way, but I am a novice and don't know what it is.
Help!!!
 
OK, the criteria is a specific route (bus business) which
will be listed for a set of dates. So I have 33 lines of
information (one for each date). I have a total in my
last field, but I need an average of all of those totals
for all of those dates. Now, I'm transferring to excel
to get the average of the totals. I know there's a
better way, but I am a novice and don't know what it is.
Help!!!
Click to expand...

The simplest way to do this on a Report is to do it right on the
Report. It's quite difficult to have both subtotals and grand totals
in the same Query, since all records have the same "rank".

Base a Report on the query which calculates your totals; in the Report
Footer put a textbox with a control source of

=Avg([totalfield])

using your own fieldname of course.

Also works in a Form footer.
 
Thank you very much. I should have thought of that. You
can't know how helpful it is that people like you take
the time to answer these questions. This project (since
there are 63 routes) was goning to take me forever
otherwise.

bb
-----Original Message-----
OK, the criteria is a specific route (bus business) which
will be listed for a set of dates. So I have 33 lines of
information (one for each date). I have a total in my
last field, but I need an average of all of those totals
for all of those dates. Now, I'm transferring to excel
to get the average of the totals. I know there's a
better way, but I am a novice and don't know what it is.
Help!!!
Click to expand...

The simplest way to do this on a Report is to do it right on the
Report. It's quite difficult to have both subtotals and grand totals
in the same Query, since all records have the same "rank".

Base a Report on the query which calculates your totals; in the Report
Footer put a textbox with a control source of

=Avg([totalfield])

using your own fieldname of course.

Also works in a Form footer.


.
Click to expand...
 
In your form or report where you need the average, enter the following in the
control source property of a textbox:

=DAvg("[NameOfTotalsField]","NameOfYourQuery")
 
Back
Top