[AccessD] Sorting textual fields like number fields?

Good lord.  I wrote an entire function to do something, and there was
already one available?  Unheard of in programming.  ;)

-C-

---- Original Message ----
From: gustav at cactus.dk
To: accessd at databaseadvisors.com, 
Subject: Re: [AccessD] Sorting textual fields like number fields?
Date: Tue, 2 Dec 2003 19:49:06 +0100

>Hi Christopher
>
>You can use Val().
>
>.. Order By Val([Address]), [Address] ..
>
>/gustav
>
>
>> All,
>
>> I feel like I should already know how to do this, but for whatever
>> reason - I don't.  Must be the pneumonia clouding my thinking. 
>> Here's the problem:
>
>> I need to sort an address field by street number.  The Address
>> (street number and street name) is contained in a Text field, so my
>> attempts to sort it end up with the numbers being sorted like text.
>> For example, given addresses 1118 Main St., 1144 Maple St., 1146 
>Oak
>> St., 113 East St. and 115 West St. the sort would look like this:
>
>> 1118 Main St.
>> 113 East St.
>> 1144 Maple St.
>> 1146 Oak St.
>> 115 West St.
>
>> I need the sort to go exactly by street number, like this:
>
>> 113 East St.
>> 115 West St.
>> 1118 Main St.
>> 1144 Maple St.
>> 1146 Oak St.
>
>> And I don't have a clue how to begin.  Heeeeeeeeeeeeeeeeeeeeeelp...
>
>> -Christopher-
>
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>