ODBiC Discussion Board

Converting number in a text field to a numeric number

by Scott S, February 17, 2005 17:36

Hello, Just looking for a little help. I have an access database with a field that is set up as a text field. Each record that is put in is a number. (1, 2, 3, 4....10, 11, 12...etc)

Is their a way to convert the numbers to a numaric number. What is happening is when the data is sorted ther are being sorted as words are. (10, 11, 12, 2, 3, 40, 41, 5...etc)

Thank you in advance.



Post Your Reply:

E-mail  optional

HTTP Link: 
Link text: 


Copyright ©1997-2003, Roger Harris. All rights reserved.