S
Stuart
This might be the wrong group (but it is my favorite)
I need to sort a list data from a text field into numerical order.
The data needs looks like this: -
a1
1
1a
2
3
4
29
29A
29X
25X
X25
However, the data could be put into the database in any order with additions
by a user so I cannot rely on using an autoID.
I am using MS Access (I could use MySQL if it would make life easier, but
not MS SQL Server as we do not have a licence for it)
Any help would be greatly appreciated !!!
regards,
Stuart
I need to sort a list data from a text field into numerical order.
The data needs looks like this: -
a1
1
1a
2
3
4
29
29A
29X
25X
X25
However, the data could be put into the database in any order with additions
by a user so I cannot rely on using an autoID.
I am using MS Access (I could use MySQL if it would make life easier, but
not MS SQL Server as we do not have a licence for it)
Any help would be greatly appreciated !!!
regards,
Stuart