I have a dropdown on my Access form (frmStudent)
SELECT tblTeachers.tblTeachersID, tblTeachers.tblTeachersName FROM tblTeachers ORDER BY tblTeachers.tblTeachersName, tblTeachers.[tblTeachersName];
The concern is this:
The Teachers names go like:
As you can see when names are entered like this I am unable to sort on the first letter. Is there any way I can modify the query to sort the first letter after (period - space) [. ] ?
...or would there be a better way to do this. The drop down view must look like the names above.
Kind of need this in a hurry so I am offering max points.