By choosing these two fields, you tell Access that you want to sort records in this order, but
you need to go one extra step to group records: In the Sorting and Grouping dialog box,
select the row that contains the Supplier field and change the Group Header property to
Yes. If you want to add a footer for this section, change the Group Footer property to Yes as
well.
Troubleshooting
Importing Hyperlinks into Access
I imported a list filled with hyperlinks into an Access table, but none of my hyperlinks work properly.
What happened?
When you create a table by importing data, Access automatically recognizes a column that
contains URLs ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.