Sorting by multiple categories

[Laura1982]

I have a list of employees that I would like to sort by state, and then those within each state, in alphabetical order.

However, when I sort the state and then go to sort the last names, the states rearrage themselves.

It has to be a query.

Any help much appreciated.

 

[Brianwarnock]

Hi

a query with state as the first field and emploees as the second, both sorted ascending should do the trick.

Brian

 

[FoFa]

In the QBE grid, it takes from left to right the order of the sort. So if you want Name left of state in your query, you can add name at the end of your query, then select it for sort, but check the box to NOT display it so name would appear twice in the grid. Or you can move state to the left of name.