Generally Access will automatically accept a string that is a representation of
a number as a valid entry in a numeric field without an explicit conversion so
long as it is within the size of the field in question. If you want to
explicitly make the conversion you can use whichever of the following is
appropriate.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.