Access: CDec Function
Question: How do I convert a value to a decimal number?
Answer: To convert a value to a decimal number, use the "CDec" function. The syntax for the CDec function is:
CDec( expression )
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.