But isn't this limitation of Access even more of an arguement for teaching Access hobbyist to design data fields in a logical fashion? It really seems the problem is being framed as "How do I keep the leather on my shoes from getting messed up when I swim?" < bg >
>>Will be interested to see the one-line solution.
>
>Sorry, Charles, forgot to include you in my response to Hilmar, about Access and "no expressions in indexes". So, there is no viable solution in this direction.
>
>Back to the drawing board! The only assumnption here is that we have perhaps 50,000 or more hobby Access users that have/want a 1-column sort for this ordering.
>
>Back to he drawing board. Maybe an SQL solution, I'm gonna look at that first.
>
>I don't know if this qualifies as an "upside" but I *am* learning a lot more about MS Access doing this project, than I did before I began it :-)
Charles Hankey
Though a good deal is too strange to be believed, nothing is too strange to have happened.
- Thomas Hardy
Half the harm that is done in this world is due to people who want to feel important. They don't mean to do harm-- but the harm does not interest them. Or they do not see it, or they justify it because they are absorbed in the endless struggle to think well of themselves.
-- T. S. Eliot
Democracy is two wolves and a sheep voting on what to have for lunch.
Liberty is a well-armed sheep contesting the vote.
- Ben Franklin
Pardon him, Theodotus. He is a barbarian, and thinks that the customs of his tribe and island are the laws of nature.