Hi All!!
I have a little problem that I can't seem to get around. I am using part numbers in my database. These part numbers have dashes in them. Because the part numbers have dashes in them, I must use a text field, however when I try to organize them in ascending order they go by the first number, not the whole number before the dash. In other words a part number like 11-3-23, would come before 4-2-22 because the first number is a one (and not eleven).
Do you know of any way that I can get over this obstacle, so that the numbers between the dashes can be treated like numbers instead of text? I would love to put imaginary zeros in front of the numbers between the dashes (this would solve the problem), but I don't know how, and I don't want to ever see them. If it matters, the first number can be one or two digits, the second number can be one or two digits, and the third number can have any where from one to four digits.
Thanks for any help in advance!!
Wally
I have a little problem that I can't seem to get around. I am using part numbers in my database. These part numbers have dashes in them. Because the part numbers have dashes in them, I must use a text field, however when I try to organize them in ascending order they go by the first number, not the whole number before the dash. In other words a part number like 11-3-23, would come before 4-2-22 because the first number is a one (and not eleven).
Do you know of any way that I can get over this obstacle, so that the numbers between the dashes can be treated like numbers instead of text? I would love to put imaginary zeros in front of the numbers between the dashes (this would solve the problem), but I don't know how, and I don't want to ever see them. If it matters, the first number can be one or two digits, the second number can be one or two digits, and the third number can have any where from one to four digits.
Thanks for any help in advance!!
Wally