[AccessD] Sorting A Text Field

Stuart McLachlan stuart at lexacorp.com.pg
Mon Apr 14 05:55:56 CDT 2003


That's straight ASCII order, a simple Ascending sort on the text 
field should do it. What's the problem.



On 14 Apr 2003 at 9:43, paul.hartland at fsmail.net wrote:

> To all,
> 
> I don't know if this can be done, but I have a text field in a table
> which contains data similar to the following :
> 
> 7
> 3
> 9
> 2
> 5
> M5
> B2
> M1
> 
> So the data is a mixture of numbers and characters, is there anyway to
> sort the data so that the above would appear as below :
> 
> 2
> 3
> 5
> 7
> 9
> B2
> M1
> M5
> 
> Any help on this would be greatly appreciated, as it is fairly
> urgent.....
> 
> Thanks in advance.
> 
> Paul Hartland
> 
> 
> 
> 
> ______________________________________________________________________
> ____ Join Freeserve http://www.freeserve.com/time/
> 
> Winner of the 2003 Internet Service Providers' Association awards for
> Best Unmetered ISP and Best Consumer Application.
> 
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com


-- 
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System 
Support.





More information about the AccessD mailing list