Sorting and Grouping

  • Thread starter Thread starter Gregc.
  • Start date Start date
G

Gregc.

Hi

I wish to add additional Sorting and Grouping pane/panel in my report.
Is there a way that I can do this in Design View.

Thanks in Advance

Greg
 
from the menu, choose
View --> Sorting & Grouping

there is also an icon on the toolbar to turn on this window

Warm Regards,
Crystal
Microsoft Access MVP 2006

remote programming and training
strive4peace2006 at yahoo.com
*
Have an awesome day ;)
 
Have you reached the limit of 10 sorting and grouping levels? If so, it
seems this would have been significant information in your first post. If
you don't have 10 then you should tell us why you don't think you can add
more.
 
Hi Greg,

in the Sorting & Grouping window:

To add additional sections, you just need to say Yes to
GroupHeader and/or GroupFooter

To insert a row in the middle, click in the gray "selector"
box to the left of the Field/Expression -- this will select
the row -- then press the INSERT key on your keyboard (or
press DELETE if you want to remove the row)


Warm Regards,
Crystal
Microsoft Access MVP 2006

remote programming and training
strive4peace2006 at yahoo.com
*
Have an awesome day ;)
 
strive4peace said:
To add additional sections, you just need to say Yes to
GroupHeader and/or GroupFooter

To insert a row in the middle, click in the gray "selector"
box to the left of the Field/Expression -- this will select
the row -- then press the INSERT key on your keyboard (or
press DELETE if you want to remove the row)
Click to expand...

Okay, done that. But I am having trouble getting an actual bar showing
up.

Greg
 
Hi Greg

If you said YES to GroupHeader or GroupFooter, you should
see the section dividers. They won't necessarily be named
logically.

To increase or decrease the height of a section, move to the
top of the section divider below it, just above the top of
the divider line -- notice that your mouse pointer turns
into a horizontal line with a vertical doubl-headed arrow --
this is the resizing pointer -- just click and drag down or
up to give to or take from the section above your pointer.

If you don't know how a section will show up on the report,
put a label in it and do a report preview.

Warm Regards,
Crystal
Microsoft Access MVP 2006

remote programming and training
strive4peace2006 at yahoo.com
*
Have an awesome day ;)
 
strive4peace said:
To increase or decrease the height of a section, move to the
top of the section divider below it, just above the top of
the divider line -- notice that your mouse pointer turns
into a horizontal line with a vertical doubl-headed arrow --
this is the resizing pointer -- just click and drag down or
up to give to or take from the section above your pointer.
Click to expand...

What about adding additional bars, in design view.

Greg
 
I think Crystal already provided this information a few posts back (5/15
10:17 AM).
 
This is what Crystal wrote:
===============================
Hi Greg,

in the Sorting & Grouping window:

To add additional sections, you just need to say Yes to
GroupHeader and/or GroupFooter

To insert a row in the middle, click in the gray "selector"
box to the left of the Field/Expression -- this will select
the row -- then press the INSERT key on your keyboard (or
press DELETE if you want to remove the row)
===============================
 
Back
Top