WHEN YOU NEED TO GO beyond a single field sort, the Sort command (also found on the Data tab) is your ticket to multiple-field sorting. It’s also a great way to lay the groundwork for a Subtotal report, which you’ll read about in the last section of this chapter.
So why would you want to sort by more than one field? Well, sticking with the list of cities, imagine that you wanted to sort them by state and by city, so that all the cities are in state order, and within each group of states that that sort creates, the cities would be in alphabetical order. Figure 7-3 shows that sort in place.
Using Sort ...