Changing sort order
Changing sort order
(OP)
Sorting part numbers in ascending order produces the following result:
430-100
430-101
430-98
430-99
Is there any way to change the results of sorting so that part numbers would come out in the following order:
430-98
430-99
430-100
430-101
I see where it is possible to sort by days of the week and months of the year under options. Is there some way to define my own sort order?
430-100
430-101
430-98
430-99
Is there any way to change the results of sorting so that part numbers would come out in the following order:
430-98
430-99
430-100
430-101
I see where it is possible to sort by days of the week and months of the year under options. Is there some way to define my own sort order?





RE: Changing sort order
Or, change your part numbers to 430-098 etc
Cheers
Greg Locock
RE: Changing sort order
RE: Changing sort order
RE: Changing sort order
I thought that I once saw a check box option that said "treat text that looks like a number like a number", but I can't find it anymore. It might have been in a different program, maybe Access.
I did however come across this tidbit in the help:
Apostrophes (') and hyphens (-) are ignored, with one exception: If two text strings are the same except for a hyphen, the text with the hyphen is sorted last.