Hello,
I would like to convert a text string to integer.
lots of posts say to use val, but it is not listed in access 2010
So I am trying,
Creating a field that is numeric
then just referring to the string field.
this works good except where it finds actual text.
It puts the value "#Type!" in there.
Would there be some kind of function to check for an error or check if the value is text>
thank you