Modify alphabetic sort

[Guest]

I have a combo box on a form. The cb is populated from a query and displays
the Description field sorted ascending.

The problem is that there is an entry "Other" that the client wants to
appear at the end of the list. I have suggested renaming the record to
"Undefined" but that is not acceptable.

After looking at both the ASCII and ANSI tables I prefixed "Other" with "~"
and much to my surprised it was then first in the list.

Any suggestions, please

 

[Allen Browne]

You could force the word Other to the bottom of the list by setting the
combo's RowSource to something like this:
SELECT ItemName
FROM tblItem
ORDER BY (ItemName <> 'Other'), ItemName;

 

[Van T. Dinh]

You can create a Calculated Column in your Query like:

IsOther: [Description] = "Other"

which returns a boolean value 0 (False) or -1 (True)

then sort the rows returned by the Query by [IsOther] Descending first and
then the Field [Description] Ascending second.

 

[Guest]

Thank you Allen and Van

Much more elegant than my approach.
--
Graham

You can create a Calculated Column in your Query like:

IsOther: [Description] = "Other"

which returns a boolean value 0 (False) or -1 (True)

then sort the rows returned by the Query by [IsOther] Descending first and
then the Field [Description] Ascending second.

--
HTH
Van T. Dinh
MVP (Access)

I have a combo box on a form. The cb is populated from a query and
displays
the Description field sorted ascending.

The problem is that there is an entry "Other" that the client wants to
appear at the end of the list. I have suggested renaming the record to
"Undefined" but that is not acceptable.

After looking at both the ASCII and ANSI tables I prefixed "Other" with
"~"
and much to my surprised it was then first in the list.

Any suggestions, please