Follow us:
access functions

MS Access: CDec Function

This MSAccess tutorial explains 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 CDec function in MS Access is:

CDec( expression )

Parameters or Arguments

The value to convert to a decimal number.

Applies To

The CDec function can be used in the following versions of Microsoft Access:

  • Access 2013, Access 2010, Access 2007, Access 2003, Access XP, Access 2000

Example in VBA Code

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.