Currency Formatted Field Addition in MS Access Report

In Microsoft Access reports, attempting to add currency formatted fields together will result in concatenated text instead of executing proper addition.

If we have the following sample data:


The below query will result in the unexpected concatenation of each of the fields to form the string $5.00$10.00$3.00.


Using the CCur() function in the formula will return the expected $18.00 result.


Leave a Comment