Convert Text to Numeric

  • Thread starter Thread starter cp2599
  • Start date Start date
C

cp2599

I think this is pretty basic but my mind is blank ... I have stored a
numeric value in a text field in a table ... it's a table that stores
default values for all types of attributes. I want to use that value
to compare against a numeric value but can't remember how to convert
the text field to a numeric so that the compare will work.
 
Use Val([YourField]) and if the field begins with alpha character the
result will be 0 (zero).
 
Use     Val([YourField])   and if the field begins with alpha character the
result will be 0 (zero).



cp2599 said:
I think this is pretty basic but my mind is blank ... I have stored a
numeric value in a text field in a table ... it's a table that stores
default values for all types of attributes.  I want to use that value
to compare against a numeric value but can't remember how to convert
the text field to a numeric so that the compare will work.- Hide quotedtext -
Click to expand...

- Show quoted text -
Click to expand...

Thank you!!
 
Back
Top