Sorting with Alpha before Numerics

[Jay Oken]

I have a report that groups on Teacher Grade (text field). I would like
alpha to list first then in numerical order. For example:

K - Kindergarten
1 - 1st grade
2 - 2nd grade

Is there an easy way to do this.

Thanks,
J

 

[Marshall Barton]

I have a report that groups on Teacher Grade (text field). I would like
alpha to list first then in numerical order. For example:

K - Kindergarten
1 - 1st grade
2 - 2nd grade

What is in the field? If it's just K or 1 or 2 or ...
then use an expression in Sorting and Grouping. E.g.

=IIf([Teacher Grade] Like "#*", Right( "0" & [Teacher
Grade], 2), " " & [Teacher Grade])

 

[Damon Heron]

The text field is from a table, correct? Add another field to the table,
with values 0,1,2, etc corresponding to the grades with 0 for kindergarten.
Then add this new text field to you report, along side the current
textfield. Sort on the new textfield, and set its visible property to
false.

Damon