Convert a 18 character string to and int

How to conve开发者_运维知识库rt 18 character string to int in microsoft access database

e.g "999999999999999999"

You can't. An int is too small to hold a number like that.

You can convert it to the Decimal data type:

cdec('999999999999999999')