Function to convert TEXT to a STRING

[Andre Laplume via AccessMonster.com]

I know there is a MSAccess function: Cstr(value) that will convert a
numeric field to a text field. What is the function that takes a text
field (that always contains integer values....just stored as text) and
convert it to a numeric field when the make table is run.

 

[MGFoster]

I know there is a MSAccess function: Cstr(value) that will convert a
numeric field to a text field. What is the function that takes a text
field (that always contains integer values....just stored as text) and
convert it to a numeric field when the make table is run.

Try Val() for any number or CInt() for integers or CDbl() for doubles.

 

[Andre Laplume via AccessMonster.com]

Cint was the one I was think9ing of...THANKS!