John,
Thanks that worked great.
With Warm Regards,
Arthur D. Lorenzini
IT System Manager
Cheyenne River Housing Authority
Wk.(605)964-4265 Ext. 130
Fax (605)964-1070
"Only those who will risk going too far can possibly find out how far one can go."
On Tuesday, August 5, 2014 6:59 PM, "John Viescas JohnV@msn.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:
Art-
Sort on Mid([UnitCode], 3)
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Aug 5, 2014, at 6:42 PM, dbalorenzini@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
I have a field called UnitCode which is Short Text 30.
Here are a few records of what the data looks like:
| 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: Art Lorenzini <dbalorenzini@yahoo.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (4) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar