Learn how to use the Access CDec function with syntax and examples.
The Microsoft Access CDec function converts a value to a decimal number.
The syntax for the Microsoft Access CDec function is:
CDec( expression )
expression is the value to convert to a decimal number.
The CDec function can be used in the following versions of Microsoft Access:
The CDec function can be used in VBA code in Microsoft Access. For example:
Dim LDecimal As Double LDecimal = CDec(8.45 * 0.005 * 0.01)
The variable called LDecimal would now contain the value of 0.0004225.
(scroll to see more)