Qruery: Primary & secondary sort? 1

[GaborH]

I am trying to create a combo box that lists employees by job title and last name within a job title. I know that queries can only sort on field, and I can achieve a virtual primary/secondary sort with a field that would combine title and last name. But I wonder if there a simpler way of doing this?

 

[Golom]

The ORDER BY clause can sort on multiple fields and it can also sort on calculated fields. If you have, as in your example, TITLE and LASTNAME fields then
[tt]
ORDER BY Title, LastName
[/tt]
will sort by Title and, within each title, by last name. Is that what you are after?

 

[GaborH]

Golom,

You got it. Thank you!