Sorting in a query

[Niniel]

I'd like to sort in my query - used to populate a combo box - first by name, and then by ID.
Is there a way to force Access to sort in a particular order? It seems like it starts sorting with the first field that's to be sorted, but I want it to start with field 2 and then sort by field 1.

 

[FoFa]

Drag and drop Field1 (a second time) to the query (after Field2). Uncheck the DISPLAY field, and then select Field2 and the new Field1 sort order. Leave the old field1 unsorted.

 

[Niniel]

Thank you.