Selasa, 05 Agustus 2014

[MS_AccessPros] Sorting a text field in a query

 

I have a field called UnitCode which is Short Text 30.


Here are a few records of what the data looks like:



CountHUDUnits
UnitCode
LP0782
LP0783
LP0784
LP0785
LP0786
LP0787
LP0788
TK0488
TB0293
GG1001
TL1235
BR0943


I need to sort the field by the digits not the letters. Can I do that?


Thanks,


Art Lorenzini

Sioux Falls, SD

__._,_.___

Posted by: dbalorenzini@yahoo.com
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)

Yahoo Groups
New feature! Create Photo Albums in Groups Effortlessly
Now, whenever you share photos with your group, a new album is automatically created in the Group. It's so simple! Try it now!


.

__,_._,___

Tidak ada komentar:

Posting Komentar