Re: alphanumerics

Article View: comp.databases.ms-access

Article #437

Back to comp.databases.ms-access Previous Next

#437

From: Uli Reinbeck
Date: Wed, 05 Nov 1997 00:00

29 lines
2231 bytes

Hello Bruce,

could you give your question a bit more precisely?
What sorting order do you want to achieve, why do you want to use the
val-function??

Uli

--
------------------------------------------------------------
 Ulrich Reinbeck, Bismarckstr. 52, 70197 Stuttgart (Germany)
 reinbeck@tick.informatik.uni-stuttgart.de
------------------------------------------------------------


Bruce Collins wrote:

> I have a list of numbers as well as the occasional text in a text field that
> I need to sort.  ie entries could be 135, 12, 406, bru, 1128.
>
> If I sort them normally they come out as 1128,12,135,406,bru.
>
> If I use a Val function before sorting this turns the bru into a 0 value.
>
> The only solution I can see is putting zeros in front of each number but
> with 1400 entries I don't want to do this manually!!
>
> Is there a way that someone else has found to get around this problem?

Technical Details

Message-ID: <346082C2.2C571FFB@tick.informatik.uni-stuttgart.de>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <63pctq$qf9$1@fep4.clear.net.nz>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 101bdd,d15889b331bc5e2f
X-Google-Attributes: gid101bdd,public
X-Google-Thread: 111a5a,d15889b331bc5e2f
X-Google-Attributes: gid111a5a,public
X-Google-Thread: 10779a,d15889b331bc5e2f
X-Google-Attributes: gid10779a,public
X-Google-Thread: 10d1ba,d15889b331bc5e2f
X-Google-Attributes: gid10d1ba,public
X-Google-Thread: 10bb27,d15889b331bc5e2f
X-Google-Attributes: gid10bb27,public
X-Google-Thread: ff0ac,d15889b331bc5e2f
X-Google-Attributes: gidff0ac,public
X-Google-Thread: 1163bd,d15889b331bc5e2f
X-Google-Attributes: gid1163bd,public
X-Google-Thread: f5bfb,d15889b331bc5e2f
X-Google-Attributes: gidf5bfb,public
From: Uli Reinbeck <reinbeck@tick.informatik.uni-stuttgart.de>
Subject: Re: alphanumerics
Date: 1997/11/05
Message-ID: <346082C2.2C571FFB@tick.informatik.uni-stuttgart.de>
X-Deja-AN: 287212688
References: <63pctq$qf9$1@fep4.clear.net.nz>
Organization: Comp.Center (RUS), U of Stuttgart, FRG
Reply-To: reinbeck@tick.informatik.uni-stuttgart.de
Newsgroups: comp.databases.ms-access,es.comp.bd.ms-access,info.inet.access,microsoft.public.access,microsoft.public.access.developerstoolkit,microsoft.public.access.forms,microsoft.public.access.formsprogramming,microsoft.public.access.queries,microsoft.publi

Reply to Parent Message