How do I enter more than one "totals" line?

  • Thread starter Thread starter CWhite
  • Start date Start date
C

CWhite

Hi, I want to create a report that has the sum, average, minimum and maximum,
etc underneath the data in the same column as the data. Right now, all I can
figure out is how to put just one of these in a totals line underneath the
data (for instance, it only gives me one choice of what kind of info I want
to display, like "sum").
Is it possible to have multiple totals lines underneath each other?
Thanks!
 
CWhite,
Not sure I understand what you're asking. A small example of what you
want may be needed...
(This is what I have vs. this is what I need)

Given a column called SalesAmt, your calculations should be placed
in whatever Group Footer you may have, or the Report Footer.
The footer can accomodate as many calculations as necessary, stacked
under the column
Sales
10
15
30
--------
=Sum(SalesAmt) ' = 55
=Avg(SalesAmt) ' = 18.3
=Max(SalesAmt) ' = 30
=Min(SalesAmt) ' =10
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
Back
Top