I have a table with two columns the first is a file number in the format of
(i.e.) 04-63, 04-64, etc. the second is text. I want to sort by the first
column and what happens is it puts for example 04-63 right before 04-632
instead of before 04-64. I have tried replacing the "-" with "." - no help -
I've tried sorting as text, numberic and also date with no luck. These
numbers are file numbers with the "04" being the year and the -# being the
next number in the sequence of files opened that year. As we close files we
enter the number in this table. I need them to read 04-1, 04-2, 04-3, etc.
through possibly 04-632 if we opened that many files that year. I can't get
them to sort by the first two numbers (99, 00, 01, 02, 03, 04, 05) and then
by the last set of numbers 1, 2, ...100,101,). Why is this so complicated?
Any suggestions?
Sandy

This is "so complicated" because you've blundered with your "numbering"
scheme. Strings like "04-63" are not numbers, so they don't get sorted as
such. The quick fix is to insert another column, then split your strings
into two numbers, year in the first column, file number in the second. Then
sort on column 1, column 2.




"Shehi_3" wrote in message
...
I have a table with two columns the first is a file number in the format
of
(i.e.) 04-63, 04-64, etc. the second is text. I want to sort by the first
column and what happens is it puts for example 04-63 right before 04-632
instead of before 04-64. I have tried replacing the "-" with "." - no
help -
I've tried sorting as text, numberic and also date with no luck. These
numbers are file numbers with the "04" being the year and the -# being the
next number in the sequence of files opened that year. As we close files
we
enter the number in this table. I need them to read 04-1, 04-2, 04-3,
etc.
through possibly 04-632 if we opened that many files that year. I can't
get
them to sort by the first two numbers (99, 00, 01, 02, 03, 04, 05) and
then
by the last set of numbers 1, 2, ...100,101,). Why is this so
complicated?
Any suggestions?
Sandy