This MSAccess tutorial explains how to use the Access CCur function with syntax and examples.
The Microsoft Access CCur function converts a value to currency.
The syntax for the CCur function in MS Access is:
CCur( expression )
expression is the value to convert to currency.
The CCur function can be used in the following versions of Microsoft Access:
The CCur function can be used in VBA code in Microsoft Access.
Dim LValue As Double Dim LCurValue As Currency LValue = 123.4567812 LCurValue = CCur(LValue)
In this example, the CCur function would return the value 123.4568. The variable called LCurValue would now contain 123.4568.
(scroll to see more)