Sosrting numbers entered as text

[Charles via AccessMonster.com]

I would like numbers entered as text to sort in the following manner 1, 2, 9,
10, 20, 22, 2001, 2002 , , etc. right now I am getting 1, 18, 2, 21, 3, 31,
4, and so on .

Thanks

Charles

 

[quinto via AccessMonster.com]

I would like numbers entered as text to sort in the following manner 1, 2, 9,
10, 20, 22, 2001, 2002 , , etc. right now I am getting 1, 18, 2, 21, 3, 31,
4, and so on .

I foprgot to say that this should happen on the drop down menus, forms or
reports

 

[raskew via AccessMonster.com]

Hi-

Lookup the Val() function in your helpfile.

Bob

 

[fredg]

I would like numbers entered as text to sort in the following manner 1, 2, 9,
10, 20, 22, 2001, 2002 , , etc. right now I am getting 1, 18, 2, 21, 3, 31,
4, and so on .

Thanks

Charles

Add a new column to your query.
SortThis:Val([TextField])
Sort on this field.

 

[Charles via AccessMonster.com]

To fredg


Thanks
Charles

I would like numbers entered as text to sort in the following manner 1, 2, 9,
10, 20, 22, 2001, 2002 , , etc. right now I am getting 1, 18, 2, 21, 3, 31,

[quoted text clipped - 3 lines]

Charles

Add a new column to your query.
SortThis:Val([TextField])
Sort on this field.

 

[Charles via AccessMonster.com]

To fredg


Thanks
Charles

I would like numbers entered as text to sort in the following manner 1, 2, 9,
10, 20, 22, 2001, 2002 , , etc. right now I am getting 1, 18, 2, 21, 3, 31,

[quoted text clipped - 3 lines]

Charles

Add a new column to your query.
SortThis:Val([TextField])
Sort on this field.