How do I add more than one "totals" field?

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

CWhite

Hi, here is what I want to do: I want to be able to see the sum, average,
minimum and maximum, etc underneath the data in the same column as the data.
Is there a way to create a report or query that allows me to do this? It
seems like Access will only allow you to pick one "total" at a time for each
column of data.
At some point I figured out how to run a report or query that let me access
all that info, but it was in a format that read from left to right, all
across the top of the page, not in a concise, easy to read manner. Is it just
a matter of changing the view?
Thank you!
 
Stack 'em up in a union query.
SELECT Something, Sum([Something]) AS [Sum_]
FROM YourTable
UNION SELECT Something, Average([Something]) AS [Average_]
FROM YourTable
UNION SELECT Something, Max([Something]) AS [Max_]
FROM YourTable
UNION SELECT Something, Min([Something]) AS [Min_]
FROM YourTable;
 
Back
Top