How do I convert a string to a numeric value in Access?

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

Guest

I am trying to pull information from a SQL database to do some statistical
analysis. The number I want to work with is in the databas as a varchar. I
am trying to add an expression to my query that will give me the average of
the information in the field. I am not sure how to get the string value into
a numeric form.
 
Use CDbl([MyField]) to convert to a Double (real), or CLng() to convert to
long (32-bit).
 
Back
Top