Order By on Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a Report that shows Mother & Father with all there children listed
below them. How can I keep all of them together?
Example:
On my report now it list them all ok except it carries over, at bottom of
first page it will have the parents and 1 child then second page will have
only the children.
I want it to show whole family on each page without splitting families from
one page to another.
Thanks In Advance
Alvin
 
Hi, Alvin.
I have a Report that shows Mother & Father with all there children listed
below them. How can I keep all of them together?
Click to expand...

Use the Sorting and Grouping toolbar button or use the Tools -> Sorting and
Grouping menu to open the Sorting and Grouping dialog window. If you already
have a Group Header on the Parents' field name, then select this field in the
"Field/Expression" column in the upper pane, and then select "Whole Group" in
the "Keep Together" Property in the lower pane, Group Properties.

If you don't have a Group Header on the Parents' field name, then create one
by selecting the Parents' field name in the "Field/Expression" column's combo
box in the upper pane. In the Group Properties pane below, select "Yes" in
the "Group Header" Property and select "Whole Group" in the "Keep Together"
Property.

Close the Sorting and Grouping dialog window and save the report, then open
it. The children's names will appear together on the following page with the
parents' names, instead of being split between two pages.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
Beware to those who use munged addresses: known newsgroup E-mail harvesters
for spammers are (e-mail address removed) and (e-mail address removed)

- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. Remember that questions
answered the quickest are often from those who have a history of rewarding
the contributors who have taken the time to answer questions correctly.
 
Back
Top