Query -- Sort two columns

[snowboarder234]

I want to sort the first column by the grant id (Numeric) then I want the second column (last name) to be sorted alpha in accordance with the grant ID assigned to that person

For example:
04-29 Albertson
04-75 Berns
04-37 Carson

05-29 Andrews
05-35 Bacon
05-00 Castillo



06-01 Anderson
06-12 Beacon

And so forth. How do I do this?

[ssanfu]

If I understand.....there is a column, with data that looks like "04-29" and a second column with last names. You want to sort first by the two chars to the left of the dash, and second by last name?

Will the grant id always have 2 chars to the left of the dash or could it be 3 chars?

Try:

SELECT GrantID, Last_Name FROM YourTable ORDER BY left([GrantID],2), Last_Name

Change the names in blue to your table and field names.

[snowboarder234]

Yes, to your question: the grant id will always have 2 characters to the left of the dash. Never 3 characters.

Sorry, if I'm dense. But I don't understand the answer. I don't write code -- is that what you're suggesting? Or is what you've given me what I put in the first (grant ID) and second (last name) column?