How to Use Sorting & Grouping Levels in Microsoft Access Reports. Create a Grouped Report, Summary

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.

Silver Members and up get access to an Extended Cut of this video. 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.

MEMBERS VIDEO:
   • Microsoft Access Sorting & Grouping M...  

BECOME A MEMBER:
YouTube:    / @599cd  
or My Site: https://599cd.com/THMember

LEARN MORE:
https://599cd.com/Grouping

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

LINK FOR MEMBERS:
Page Renumbering: https://599cd.com/PageRenum

OTHER COURSES:
FREE Access Beginner Level 1: https://599cd.com/Free1
$1 Access Level 2: https://599cd.com/1Dollar

FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: https://599cd.com/THFree
Blank Template: https://599cd.com/Blank
Contact Management: https://599cd.com/Contacts
Order Entry & Invoicing: https://599cd.com/Invoicing
More Access Templates: https://599cd.com/AccessTemplates

ADDITIONAL RESOURCES:
Donate to my Tip Jar: https://599cd.com/TipJar
Get on my Mailing List: https://599cd.com/YTML
Contact Me: https://599cd.com/Contact
TechHelp: https://599cd.com/TechHelp
Consulting Help: https://599cd.com/DevNet
Twitter:   / learningaccess  
https://en.wikipedia.org/wiki/Microso...
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft...

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

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.