MS Access: CDbl Function
In Microsoft Access, the CDbl function converts a value to a double.
Syntax
The syntax for the CDbl function is:
CDbl( expression )
expression is the value to convert to a double.
Applies To
- Access 2013, Access 2010, Access 2007, Access 2003, Access XP, Access 2000
VBA Code
The CDbl function can be used in VBA code. For example:
Dim LDouble As Double LDouble = CDbl(8.45 * 0.005 * 0.01)
The variable called LDouble would now contain the value of 0.0004225.