• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 45. Presenting Data with Reports > Secrets of the Office Masters: Group...

Secrets of the Office Masters: Grouping Data

When designing an Access report, the default grouping options are sometimes hopelessly impractical. That's especially true when your data source is a list of hundreds of names and phone numbers or products. If you group by each name, you'll end up with a single record under each group header. But if you don't group at all, your list will be a sea of gray.

The solution? If your data source is a list of names, treat it just like the phone book and group by the first letter of the name instead. Click the Sorting and Grouping button and adjust options as those shown in the following figure.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint