data type of the function Val(stringexpr)

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

Guest

Access 2000
I've used Val(stringexpr) successfully in a select query to convert a Text
field value to a number (result is between 2 and 12) , but when I enter >2 in
the Criteria row I get a Data type mismatch error message. Why? (I can't
find a list of data types for built-in functions anywhere in the Help.)
 
Val() should work, and produce a Double.

If you want to typecast, try CDbl(), CLng(), CCur(), etc.
 
Back
Top