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.

Scott


Replies:


Post Your Reply:

Name   
E-mail  optional
Topic  
Message:

HTTP Link: 
Link text: 

          


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