By Richard Rost 8 months ago
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 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.
Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to register on my YouTube Find User page so I can set up your account here on my web site. If you're not a member, Join Today!
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
Subscribe to Grouping
Get notifications when this page is updated
Check out these other pages that may be of interest to you: