How to convert text datatype to number in access

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'?
 
D

Douglas J. Steele

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ACCESS 2010 1
datatype conversion 1
Leading Zeros and Number Datatype? 4
To calculate fields that have 'Number' & 'Text' datatype. 5
date format 2
Having trouble with calculating time differences in ms access 7
displaying related images in access 2003 forms 2
Requiring one field contingent on data in another field 0

Top