Reporting

Resolved · Urgent Priority · Version 2003

Reporting

Mark has attended:
Access Intermediate course

by - delegate Mark [1 post] (2008 Aug 12 Tue, 16:12) Reply

once i grouped a field how would I see them each on seperate pages as a report

Version	Date	Location	Places available	Book	Next place rate:
Access VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2009 Jan 8 Thu + 9 Fri	Southwark	4	book now	£475	£485
2003	2009 Feb 5 Thu + 6 Fri	Southwark	6	book now	£450	£485
2003	2009 Mar 5 Thu + 6 Fri	Southwark	7	book now	£345	£399
2003	2009 Apr 8 Wed + 9 Thu	Southwark	8	book now	£275	£399
2003	2009 May 7 Thu + 8 Fri	Southwark	8	book now	£275	£399
2003	2009 Jun 4 Thu + 5 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 11 Access VBA course dates. Bookings currently available until 5th November 2009.

RE: Reporting

by - trainer Stephen gold contributer [386 posts] (2008 Aug 13 Wed, 08:38) Reply

Hi Mark,

Thank You for your question

Open your report in design view and click on the grouping button. Select the grouped field and click on the group footer check box. This will create a new group footer section in your report.

Next open your toolbox (The button on your tool bar with the hammer and spanner icon). From your toolbox, select the page break control and draw it in the group footer section of your report.

This will force a page break before each new group of data, thus putting them on seperate pages

Regards

Stephen