- Feb 21, 2002
I've seen other posters run into this problem, but I still haven't been successful with any of the replies. My column (text data type) contains strings such as 1016+45, 695+00, 818+12, etc. It sorts in the order listed; I need it 695+00, 818+12, 1016+45. I have tried the Val function which works until I try to sort. Then I get a data type mismatch error. I thought maybe the Format function -- something like Format([StationOne], "0000000000") would work, but it does not place leading zeros before the string. It returns the same thing as [StationOne]. Any ideas would be greatly appreciated.