Sort ascending & descending button

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

The sort button does not appear to be functioning properly. For example. I
ask it to sort unit numbers 1,2,3,4,5,6,7,8,9,10 & 11 and the records are
displayed in the following order 1,10,11,2,3,4,5,6,7,8,9. It appears to be
sorting the first number only. Can this be changed?
 
How1 said:
Hi,

The sort button does not appear to be functioning properly. For example. I
ask it to sort unit numbers 1,2,3,4,5,6,7,8,9,10 & 11 and the records are
displayed in the following order 1,10,11,2,3,4,5,6,7,8,9. It appears to be
sorting the first number only. Can this be changed?
Click to expand...

The column you are attempting to sort is a text field. Change this to a
numeric (integer, long) field and your sort will work as planned.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Include Function in Sort 8
Sort Ascending/Descending 2
Sorting by Measurements? Access 2K 2
Sort Datasheet View with Menu AZ item 2
Sorting filtered list on form with a Command Button 5
Ascending Sort formula, change to neg #: descending sort.. 6
VBA- Excel Programming:- 0
Orderby function with reverse sort 3

Back
Top