access+vba+courses+london - Access introduction

Resolved · Low Priority · Version Standard

Access introduction

Paul has attended:
Excel Intermediate course
Powerpoint Introduction course
Access Introduction course
Excel Advanced course

by - delegate Paul [3 posts] (2008 Jan 23 Wed, 16:26) Reply

How do you subtotal on reports?

Version	Date	Location	Places available	Book	Next place rate:
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Dec 5 Fri	Bloomsbury	4	book now	£224	£224
2003	2008 Dec 9 Tue	Bloomsbury	0	FULL
2002/XP	2008 Dec 11 Thu	Tooting	0	FULL
2003	2008 Dec 18 Thu	Bloomsbury	2	book now	£215	£215
2003	2008 Dec 23 Tue	Bayswater	8	book now	£182	£207
2002/XP	2008 Dec 24 Wed	Tooting	0	FULL
Full Schedule: See all 52 Access Intermediate course dates. Bookings currently available until 24th November 2009.

RE: Access introduction

by - trainer Carlos gold contributer [479 posts] (2008 Jan 28 Mon, 10:19) Reply

Hi Paul

To create a subtotal in the report you first need to have a report with a Group Header and Footer.

The Group Header contains the value for which you need the sub totals

To create a Group Header and Footer area:

1. Click the Sorting and Grouping button on the toolbar

2. Change to Yes the Property for the Group Header/ Footer as required

In the report make sure the item to be grouped eg Productname is in the Group Header area. (This groups all the like products together)

To add a Sub Total:

1. In the Group Footer area place a Text box in line with the numeric value in the Detail area eg Amount

2. In the Text box add the code =Sum([Amount])

3. When the report is run, the Sub Total will appear everytime a new product group appears.

If the above is done in the Report Footer area the system will produce a Grand total of the selected value

Hope this helps

Carlos