W
Warren Kelley
I have a strang issue I am querying data through ODBC on a sql 2K database
looking at it with Access XP. the number field is showing 1 then 10, 11, 12
then 2, 3 ,4, on sort ascending.
I need it to show 1, 2, 3, 5,6,7,8,9,10,11
I know there ia a sql code that will allow it but when I enter it it comes
back not proper syntax. Does someone have a better solution?
thanks
looking at it with Access XP. the number field is showing 1 then 10, 11, 12
then 2, 3 ,4, on sort ascending.
I need it to show 1, 2, 3, 5,6,7,8,9,10,11
I know there ia a sql code that will allow it but when I enter it it comes
back not proper syntax. Does someone have a better solution?
thanks