How to convert data (String) to Numeric in access query?

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

Guest

I want to convert string data typt (i.e. "00000380") to numeric in access
query, not in VBA. it seems simple enough that there should be a key word
(i.e. INTEGER?) in access to do so. But I could not find any key word to
convert the data.
 
Hi,
CLng() is what you're looking for.
Keep in mind that you're going to lose the leading zeros.

You can also use CInt() if the numbers won't be higher than 32,000
 
Back
Top