Changed Number Field to Text, but Need Number Order

K

Karl Burrows

I converted a number value field to text, but now it sorts in text order
instead of number order. Is there a way to have it sort in numeric order
instead? Thanks!
 
K

Ken Snell [MVP]

Add a calculated field to your query:
TheNumber: Val([NumberAsTextField])

Sort on this calculated field.
 
K

Karl Burrows

This works to keep the numeric values in order, but if there are 2a, 2b, 2c,
then they do not appear in this value and can not be sorted in the correct
order. How can I sort it in numeric order with the text order following in
secondary sort order?

Thanks!

Add a calculated field to your query:
TheNumber: Val([NumberAsTextField])

Sort on this calculated field.
 
K

Ken Snell [MVP]

Add a sort on the entire field, and have it be the field to the right of the
TheNumber field in the query.

--

Ken Snell
<MS ACCESS MVP>

Karl Burrows said:
This works to keep the numeric values in order, but if there are 2a, 2b,
2c,
then they do not appear in this value and can not be sorted in the correct
order. How can I sort it in numeric order with the text order following
in
secondary sort order?

Thanks!

Add a calculated field to your query:
TheNumber: Val([NumberAsTextField])

Sort on this calculated field.

--

Ken Snell
<MS ACCESS MVP>

Karl Burrows said:
I converted a number value field to text, but now it sorts in text order
instead of number order. Is there a way to have it sort in numeric order
instead? Thanks!
Click to expand...
Click to expand...
 
K

Karl Burrows

Thank you!!!!

Add a sort on the entire field, and have it be the field to the right of the
TheNumber field in the query.

--

Ken Snell
<MS ACCESS MVP>

Karl Burrows said:
This works to keep the numeric values in order, but if there are 2a, 2b,
2c,
then they do not appear in this value and can not be sorted in the correct
order. How can I sort it in numeric order with the text order following
in
secondary sort order?

Thanks!

Add a calculated field to your query:
TheNumber: Val([NumberAsTextField])

Sort on this calculated field.

--

Ken Snell
<MS ACCESS MVP>

Karl Burrows said:
I converted a number value field to text, but now it sorts in text order
instead of number order. Is there a way to have it sort in numeric order
instead? Thanks!
Click to expand...
Click to expand...
 
Top