Grouping on a report

G

Guest

I have a report with Group information. I want to group by the Group number.
There can be multiple group numbers and I want each group number to have it's
own page. I have the sorting and grouping set to group by GrpId. The Group
on is set to Each Value, the Keep Together is set to Whole Group. My report
is still putting more than one GrpId on a page. Any other suggestions?

Thanks.
 
J

John Spencer

add a group footer for the Grpid
Close the Sorting and grouping dialog.
In design view Set New Page to After Group for the group footer.

Or in the group header set New Page to Before Group


--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
G

Guest

Select the Group Header bar in design mode. Set the Force New Page property
as needed.
 
G

Guest

Thanks this worked.

John Spencer said:
add a group footer for the Grpid
Close the Sorting and grouping dialog.
In design view Set New Page to After Group for the group footer.

Or in the group header set New Page to Before Group


--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Report - Sorting and Grouping 1
Grouping 2
Group Totals and Grand Totals on each page 3
Sorting by one field, Grouping by another? 1
Access Sorting and grouping using multiple tables 0
Report Group Header 9
want to add sum fields in different sections of a report 1
How do I sort by calculated field 1

Top