I recently learned that I have to format most fields that have to do with money amounts to CURRENCY, because large amounts ACCESS round the cents of even if the decimals are set to 2. I wanted the currency symbol not to show, we achieved that. It seems when I have calculated fields in a query, and then put on a report, the report does not show the decimals.