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

[Natalie]

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!

 

[Duane Hookom]

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

 

[Natalie]

Could you clarify? I'm starting to understand what you're saying.

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

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

--
Duane Hookom
MS Access MVP
--

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!

 

[Rick Brandt]

Could you clarify? I'm starting to understand what you're saying.

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

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?

 

[Natalie]

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]

I figured it out! Thank you so much!

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.