J
JohnLute
I've got a table with a field I'd like to sort alphabetically. The filed is
the primary key. It is a text field that has some entries that contain text
and numerical values. For example:
Wood Class 1
Wood Class 2
Wood Class 3
Wood Class 10
Wood Class 20
Of course, the table sorts them in this manner:
Wood Class 1
Wood Class 10
Wood Class 2
Wood Class 20
Wood Class 3
Is there a way I can sort these in true numerical sequence as above? I'm
using this table as the Row Source for a combo box LookUp and having the
numbers sorted in sequence is the preference.
THANKS!!!
the primary key. It is a text field that has some entries that contain text
and numerical values. For example:
Wood Class 1
Wood Class 2
Wood Class 3
Wood Class 10
Wood Class 20
Of course, the table sorts them in this manner:
Wood Class 1
Wood Class 10
Wood Class 2
Wood Class 20
Wood Class 3
Is there a way I can sort these in true numerical sequence as above? I'm
using this table as the Row Source for a combo box LookUp and having the
numbers sorted in sequence is the preference.
THANKS!!!