Several times I had to correct database tables with a character primary key (which is ok, if not all other tables had numeric …). In order to get the necessary numeric format I inserted another variable with the correct format and transformed the character variable to numeric using the CDbl() Function.
The syntax for the CDbl function is:
I did forget it again and could not find any documentation. Googling the topic gave a lot of fruitless hits, so here it is.