How do I subtotal groups in Reports with Access

[PeanutB7]

Hi Folks

I am looking to subtotal each group in a report while stiull providing all of the record detail that makes up the subtotal. How would I go about doing that in an Access querry or report. I can create the querry which provides all of the records grouped by category. I just can not figure out the way to subtotal.

Please Help

JB

 

[fneily]

Should be posted in Microsoft: Access Reports

Did you try just using the report wizard, when you select a group then click the summary button, will create subtotals?

Using the Sorting and Grouping button and the Group Header and Group Footer options with an unbound textbox?

You may want to see:
Create an expression

http://office.microsoft.com/en-us/access/HA011813841033.aspx

Paragraph on Summing and Counting

Page Subtotals Access Reports

http://www.blueclaw-db.com/page_subtotals_access_reports.htm

 

[PeanutB7]

fneily,

Thanks for the prompot response. I have used the report wizerd and can achieve a summary report but at the cost of losing the detail that composes the subtotal. Is there a way to provide each record of detail per category with a subtotal below before moving onto the next category of detail.

As an example:

Record Category Amount
1234 Electrical 1,000.00
1235 Electrical 2,000.00
1236 Electrical 3,000.00
Subtotal for Electrical 6,000.00

1237 Plumbing 4,000.00
1238 Plumbing etc.........

I will view the suggested sites as well and again thank you sooooo much,

JB

 

[genomon]

Try a text box using the DSUM() function with WHERE clause.

"Don't be irreplaceable. If you can't be replaced, you can't be promoted."

 

[fneily]

I don't understand. If you use the report wizard, you'll get a screen asking you to Group. You would group on Category, then you'll see a screen with button that says Summary. When you click on it, you'll get options to sum, min, max, etc. You check Sum, then click ok and continue the wizard and it'll produce exactly that report. I just don't know.