Reports in Access, can I include subtotals at the details section?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Access 2003 Reports

I understand how to include totals at the footer section, but how can I
subtotal at the details section?

Thanks for your help!
 
You can set text box control sources to something like:
=Sum([Qty])
even in the detail section.
 
Could you clarify? I'm starting to understand what you're saying.

I'm trying to subtotal $ amounts within the detail.

Duane Hookom said:
You can set text box control sources to something like:
=Sum([Qty])
even in the detail section.

--
Duane Hookom
MS Access MVP
--

Natalie said:
Access 2003 Reports

I understand how to include totals at the footer section, but how can I
subtotal at the details section?

Thanks for your help!
Click to expand...
Click to expand...
 
Natalie said:
Could you clarify? I'm starting to understand what you're saying.

I'm trying to subtotal $ amounts within the detail.
Click to expand...

Sum() aggregates fields across rows. Since the detail section by definition
only contains one row what would you expect a Sum() of one row to look like?
 
I'm trying to subtotal mulitple rows within the detail. Like Excel uses the
formula =subtotal(9,...). Is there a way to do that in access?
 
Natalie said:
I'm trying to subtotal mulitple rows within the detail. Like Excel
uses the formula =subtotal(9,...). Is there a way to do that in
access?
Click to expand...

No, there has to be something that the rows you want summed have in common and
then you group on that something. Then you can sum in the group header or
footer based on that grouping.
 
I figured it out! Thank you so much!

Rick Brandt said:
No, there has to be something that the rows you want summed have in common and
then you group on that something. Then you can sum in the group header or
footer based on that grouping.
Click to expand...
 
Back
Top