Convert Text to Numeric

[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.

 

[KARL DEWEY]

Use Val([YourField]) and if the field begins with alpha character the
result will be 0 (zero).

 

[cp2599]

Use     Val([YourField])   and if the field begins with alpha character the
result will be 0 (zero).

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 -

- Show quoted text -

Thank you!!