Solved

Access - Query with Sorting on 10 character Text field Alphanumeric

Posted on 2014-01-04
3
777 Views
Last Modified: 2014-01-04
Hi all

Is there a way to sort a query on a text field that's alphanumeric where the field can be anywhere from 1 to 10 characters and Alpha can be in any position and Number can be in any position?

Obvious to you experts just sorting gives me

1
10
100
11
12
2
21
3

etc...
0
Comment
Question by:wlwebb
  • 2
3 Comments
 
LVL 49

Accepted Solution

by:
Gustav Brock earned 500 total points
ID: 39756401
You can sort on Val([YourField])

/gustav
0
 

Author Closing Comment

by:wlwebb
ID: 39756414
PERFECT!!!!
0
 
LVL 49

Expert Comment

by:Gustav Brock
ID: 39756435
Thanks!

/gustav
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now