subtotal and grandtotal like items in a report

[granola911 via AccessMonster.com]

Hi,

thanks in advance for any help...

I'm just getting into Access in a real way so forgive if this is remedial.

I am building an invoice. I group my line item charges by chargeCat by
categories, Labor, Materials, etc, in a grouping section. I get a result
like this:

Task: demo old bathroom
Labor $300
Materials $20
Task: install new fixtures
Labor $375
Materials $540
Subcontracting $450
...
I'd like to finish the invoice with grandtotals for each item like this:

Total Labor $675
Total Material $560
Total Subcontracting $450

but I'm stuck. I can only get a full project total.

Thanks for helping

 

[Duane Hookom]

If you want the details and the subtotal list in the report footer, you will
need to use a subreport based on a chargeCat totals query.

 

[John Spencer]

While Daune is correct in that a sub-report would be the best solution, you
can get sub-totals by category.

For instance to get the labor sub total
== Add a textbox control to the report's footer
== Name the control something like SubTotalLabor
== Set the control's source to something like the following (use field names
NOT control names) and include the equal sign at the beginning
= Sum(IIF([ChargeCat]="Labor",[ChargeCost],0))

Repeat for other sub-totals

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[Duane Hookom]

John's solution will work great if you always have a static list of
categories. In your statement "Labor, Materials, etc" it's the "etc" that
bytes you in the rear.

--
Duane Hookom
Microsoft Access MVP

While Daune is correct in that a sub-report would be the best solution, you
can get sub-totals by category.

For instance to get the labor sub total
== Add a textbox control to the report's footer
== Name the control something like SubTotalLabor
== Set the control's source to something like the following (use field names
NOT control names) and include the equal sign at the beginning
= Sum(IIF([ChargeCat]="Labor",[ChargeCost],0))

Repeat for other sub-totals

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

If you want the details and the subtotal list in the report footer, you will
need to use a subreport based on a chargeCat totals query.

.