Sorting Information in Tables 849
The table reverts to the previously saved sort order. Now let’s sort both columns
at the same time.- Click the City field name, hold down the Shift key, and click the Region field name.
Then in the Sort & Filter group, click the Ascending button.
Because the City field is to the left of the Region field, Access cannot achieve the
result you want.
The City sort is overriding the Region sort.- Clear the sort, and then click away from the City and Region fields to clear the
selection. - Click the Region field name, and drag the field name to the left of the City field
name, releasing the mouse button when a heavy black line appears between the
Address and City field names. - With the Region field selected, hold down the Shift key, and click the City field
name to include that field in the selection. - In the Sort & Filter group, click the Ascending button.
Access arranges the records with the regions in ascending order and the cities in
ascending order within each region.