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: John Viescas <johnv@msn.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
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