Convert Text to Numbers

If you save numeric-based data as text when you don't need the entries for calculations, you can still use the data in calculations if necessary. Simply use the Val() function to return the numerical value of the data. You can use a query expression or a calculated control in a form or report to display the results.

However, the Val() function considers values from left to right only and stops when it encounters an alpha character. That means the Val() function won't return a value for entries that begin with alpha characters. In other words, the two entries 123abc and abc123 respond differently to the Val() function. 123abc returns the value 123, and abc123 returns nothing.

Access Index

Main Index