Re: alphanumerics

Article View: comp.databases.ms-access

Article #438

Back to comp.databases.ms-access Previous Next

#438

From: Mike S.
Date: Thu, 06 Nov 1997 00:00

26 lines
2207 bytes

Bruce,
Here is a way around it.  Try this query (assuming the field SomeID holds
the 135, 12, 406...):

SELECT MyTable.SomeID FROM MyTable ORDER BY Right("00000" & [SomeID], 5);

Use as many zeros as needed and cut it to a size you know it is safe and not
going to trim your id.

Mike S.
Optimal Systems Corp.  www.oscorp.com
----------------------------------------------------------
Bruce Collins wrote in message <63pctq$qf9$1@fep4.clear.net.nz>...
>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: <63u9lg$7nj@examiner.concentric.net>

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: 10d1ba,d15889b331bc5e2f
X-Google-Attributes: gid10d1ba,public
X-Google-Thread: f5bfb,d15889b331bc5e2f
X-Google-Attributes: gidf5bfb,public
X-Google-Thread: 10779a,d15889b331bc5e2f
X-Google-Attributes: gid10779a,public
X-Google-Thread: 10bb27,d15889b331bc5e2f
X-Google-Attributes: gid10bb27,public
X-Google-Thread: 1163bd,d15889b331bc5e2f
X-Google-Attributes: gid1163bd,public
X-Google-Thread: 111a5a,d15889b331bc5e2f
X-Google-Attributes: gid111a5a,public
X-Google-Thread: ff0ac,d15889b331bc5e2f
X-Google-Attributes: gidff0ac,public
From: "Mike S." <optimal@oscorp.com>
Subject: Re: alphanumerics
Date: 1997/11/06
Message-ID: <63u9lg$7nj@examiner.concentric.net>
X-Deja-AN: 287594921
References: <63pctq$qf9$1@fep4.clear.net.nz>
X-MimeOle: Produced By Microsoft MimeOLE V4.71.1712.3
Organization: Optimal Systems Corp.
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