alphanumerics

Article View: comp.databases.ms-access

Article #433

Back to comp.databases.ms-access Previous Next

#433

From: Bruce Collins
Date: Wed, 05 Nov 1997 00:00

12 lines
1723 bytes

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: <63pctq$qf9$1@fep4.clear.net.nz>

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

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 101bdd,d15889b331bc5e2f,start
X-Google-Attributes: gid101bdd,public
X-Google-Thread: 111a5a,d15889b331bc5e2f,start
X-Google-Attributes: gid111a5a,public
X-Google-Thread: 10779a,d15889b331bc5e2f,start
X-Google-Attributes: gid10779a,public
X-Google-Thread: ff0ac,d15889b331bc5e2f,start
X-Google-Attributes: gidff0ac,public
X-Google-Thread: f5bfb,d15889b331bc5e2f,start
X-Google-Attributes: gidf5bfb,public
X-Google-Thread: 1163bd,d15889b331bc5e2f,start
X-Google-Attributes: gid1163bd,public
X-Google-Thread: 10bb27,d15889b331bc5e2f,start
X-Google-Attributes: gid10bb27,public
X-Google-Thread: 10d1ba,d15889b331bc5e2f,start
X-Google-Attributes: gid10d1ba,public
From: "Bruce Collins" <your_login@clear.net.nz>
Subject: alphanumerics
Date: 1997/11/05
Message-ID: <63pctq$qf9$1@fep4.clear.net.nz>
X-Deja-AN: 287140054
X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3
Organization: CLEAR Net
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