Good afternoon and TGIF!!

I have a database program that supports a survey process. I need to be able to sort questions by question number and subitem, for instance 1a, 1b, 1 c, etc.

I have the question number in a field and the subitem in another
Qst_Number, Qst_Subitem

This works great until they go over 26 subitems and start using "aa", "bb", "cc", and so on.

When I sort the records by Qst_Number, Qst_Subitem I get
a
aa
b
bb
c
cc
etc.


I need a through z, then aa through zz

I use the sort when I send the data to Word for reports. Using an ADO recordset of data pulled from an Access Table.

"SELECT * FROM SurveyQuestionnaire_SurveyID ORDER BY Qst_Number, Qst_Subitem"

Any suggestions??

Thanks,
Mary