How to convert text datatype to number in access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have entered value in a field say time1 of datatype "text" and i want to
use the time1 value in another form which is of datatype "number" in
MS-Access.

How to convert the value of datatype 'text' to 'number'?
 
There are a number of conversion functions, one for each data type: CInt
will convert to Integer, CLng will convert to Long Integer, CSng will
convert to Single, CDbl will convert to Double, and CCur will convert to
Currency. There's also a Val function.
 
Back
Top