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

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!
 
K

KARL DEWEY

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;
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top