Sorting - New page for each group

[kbrooks]

I swear I've read this before but am unable to find it in the search.

I have a report that displays information entered by user. I have it sorting by user initials, which is great. But I'd like it to jump to a new page every time it hits a new set of initials. Is this possible?

 

[st3ve]

Yes. Open report in design view and right click in the detail area. Select 'Sorting ang grouping'. Group header = YES, Group On = Each Value, Keep together = Each Group.

 

[kbrooks]

My problem was I wanted to sort on a field without a header. I'd still rather not have one, but ah well....it works this way!

Thanks!