Sort by Summary Fields
I have a list of Names and Addresses. I have a Summary which shows me how many people live at a certain address. I created this by 'counting' the number of names entries at a particular address. Now I need to SORT the list of address in Descending order with the Addresses with the most people, (e.g. an apartment building) at the top and the addresses with the least people (e.g. single family homes) at the bottom.
I could really use some help! If there's a better way to do this I would be eager to learn.
Open the Sort Records Dialog and specify the sort order you need to group the records by Address, then select the option at the bottom to "Reorder based on summary field."