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.
Name E-mail optional TopicMessage:
HTTP Link: Link text: