Developing a Query

  • Thread starter Thread starter Tammy
  • Start date Start date
T

Tammy

I know how to summarize data in a query, but I want a
query that will summarize data two ways. One the sum for
each individual for the period in question, then two the
sum for all the individuals together (TOTAL). How do I do
this?
 
I know how to summarize data in a query, but I want a
query that will summarize data two ways. One the sum for
each individual for the period in question, then two the
sum for all the individuals together (TOTAL). How do I do
this?
Click to expand...

You don't, not in a Query. All records in a Table or a Query are at
the same "level" - you can't (at least not at all easily) have a Query
with both a subtotal *and* a total.

Instead, do your totalling in the footer of a Form or a Report; in a
Report you can have multiple levels of subtotals, using the Report's
sorting and grouping feature.

Query datasheets are *very* limited and should not be used for
reporting!
 
Back
Top