Figured it out. Maybe I just need to sound it out first with you guys to be able to figure it out.
SELECT tblUnit.UnitCode, tblUnit.UnitNumber
FROM tblUnit
WHERE (((tblUnit.HUDFlag)=True))
ORDER BY Right([UnitCode],4);
FROM tblUnit
WHERE (((tblUnit.HUDFlag)=True))
ORDER BY Right([UnitCode],4);
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: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 (2) |
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