Prev: Quit Database
Next: Combo box filter before form opens
From: Mike Painter on 17 Feb 2010 00:20
kenrav wrote:
> I understand that. In fact, that's how it's currently handled. The
> question is how can I sort alphanumeric values in ascending order in
> a slightly different way. By default, Access sorts alphanumeric
> values like this: A1, A11, A2 whereas I need it to sort as follows:
> A1, A2, A11.
>
You can't without using calculated fields or splitting off the alpha part.


First  |  Prev  | 
Pages: 1 2
Prev: Quit Database
Next: Combo box filter before form opens