[AccessD] Sorting A Text Field

To all,

I don't know if this can be done, but I have a text field in a table which contains data similar to the following :

7
3
9
2
5
M5
B2
M1

So the data is a mixture of numbers and characters, is there anyway to sort the data so that the above would appear as below :

2
3
5
7
9
B2
M1
M5

Any help on this would be greatly appreciated, as it is fairly urgent.....

Thanks in advance.

Paul Hartland




__________________________________________________________________________
Join Freeserve http://www.freeserve.com/time/

Winner of the 2003 Internet Service Providers' Association awards for Best Unmetered ISP and Best Consumer Application.