[AccessD] Sorting A Text Field

then the solution is to format the numbers with leading zeros
Lembit Soobik

----- Original Message -----
From: <paul.hartland at fsmail.net>
To: <accessd at databaseadvisors.com>
Sent: Monday, April 14, 2003 2:51 PM
Subject: Re: Re: [AccessD] Sorting A Text Field


> The problem comes when I have the following, sorry forgot to include this
>
> 33
> 4
> 2
> 3
>
> comes out as
> 2
> 3
> 33
> 4
>
> From: "Stuart McLachlan" <stuart at lexacorp.com.pg>
> Date: Mon 14/Apr/2003 10:55 GMT
> To: <paul.hartland at fsmail.net>,  accessd at databaseadvisors.com
> Subject: Re: [AccessD] Sorting A Text Field
>
> 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.
>
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
> __________________________________________________________________________
> 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
>