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:
Jan Feb Mar
$5.00 $10.00 $3.00
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.