MS Access: Val Function
The Microsoft Access Val function accepts a string as input and returns the numbers found in that string.
Val Function (Syntax)
The syntax for the Val function is:
Val ( string )
string is a string expression.
The Val function will stop reading the string once it encounters the first non-numeric character. This does not include spaces.
The Val function can be used in the following versions of Microsoft Access:
- Access 2013, Access 2010, Access 2007, Access 2003, Access XP, Access 2000
|Val ("10 Main Street")||would return 10|
|Val ("34 10 Main Street")||would return 3410|
|Val (" 34 10 Main Street")||would return 3410|
|Val (" 34 - 10 Main Street")||would return 34|
|Val ("075")||would return 75|
Val Examples (in VBA Code)
The Val function can be used in VBA code in Microsoft Access. For example:
Dim LNumber As Double LNumber = Val ("56.2 tables")
In this example, the variable called LNumber would now contain the value of 56.2.
Val Examples (in SQL/Queries)
You can also use the Val function in a query in Microsoft Access.