How do you sort a text field alphabetically by the first letter of the field
while ignoring the numbers.
For example, I would like my records to be sorted as follows:
A
B
45-C
G
123-P
T
Thanks for your help

One way would be to write a function that returns the first letter in the
field, add a computed field to your query that returns the value of that
function and then sort on that computed field.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Deb Tech" <Deb (E-Mail Removed)> wrote in message
news:4D13DD24-8511-4151-B9A3-(E-Mail Removed)...
> How do you sort a text field alphabetically by the first letter of the
> field
> while ignoring the numbers.
> For example, I would like my records to be sorted as follows:
> A
> B
> 45-C
> G
> 123-P
> T
> Thanks for your help

On Sun, 4 Jun 2006 08:53:01 -0700, Deb Tech wrote:

> How do you sort a text field alphabetically by the first letter of the field
> while ignoring the numbers.
> For example, I would like my records to be sorted as follows:
> A
> B
> 45-C
> G
> 123-P
> T
> Thanks for your help

The Text is always preceded by a hyphen?
Add a new column to your query.

SortThis:IIf(InStr([FieldName],"-")>0, Mid([FieldName],
InStr([FieldName], "-") +1),[FieldName])

Sort on this column.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail