Sorting & Grouping in Microsoft Access Reports

In this video, I will teach you how to use Sorting & Grouping Levels in your Microsoft Access reports to group like information together.

Adam from Newport, Vermont (a Platinum Member) asks: I want to prepare a nice report showing the contact history for each of my customers for the past year. I know how to create a query to link together the customer table with the contact table so I can show the results I want that way, however is there any way to group all of one customer's contacts together so I don't have to keep seeing his name repeat on each line? Thanks.

Members

Members will learn how to apply the same techniques to our Order Entry system. We will learn how to print multiple invoices at the same time. We will print all invoices for a customer, all unpaid invoices for a customer, or all unpaid invoices for all customers. This is great for doing monthly batch invoicing.

•  Extended Cut Video - Silver
•  Database Download - Gold

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Suggested Course

• Access Expert 12: https://599cd.com/ACX12

Links

• Blank Template: https://599cd.com/Blank
• Contacts: https://599cd.com/Contacts
• Relationships: https://599cd.com/Relationships
• Can Shrink: https://599cd.com/CanShrink
• Concatenation: https://599cd.com/Concat

Member Link

• Page Renumbering: https://599cd.com/PageRenum

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Diamond Sponsors - Information on our Sponsors Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, group, grouping, grouping level, sorting and grouping, sort group, sorting and grouping level, group by, Create a grouped or summary report, sorting and grouping data in reports, sort and filter groups, group in reports, How to Group a Report in Access, Grouping and Summarizing Data in Microsoft Access Reports, how to create a summary report in access