Decimals errors in reports



I have created an access report with averages pulled from a query. Th
many active boxes displaying averages with decimals out to umptee
digits. In the report, I have formatted the field propertie
(“Properties, Decimal”) to 2 digits for all fields, but some, not all
of the fields won't truncate the decimal to two digits. Others do. I
it were a consistent problem, I wouldn’t be surprised, but this i
driving me nuts. My reports look messy with some of the field
truncated to two decimals, other string on forever.

PS: I looked at the raw data, all contain decimals out to at least





If for some reason your underlying query returns the values as strings
rather than numbers, this could occur (the most common reason that could
occur is if you have a calc for that field that says something like IF,
value is good then return the number, Else return Null; where you should
return a 0 rather than a null. That type of IIF statement will cause the
field to output numbers as strings.)

You want nulls rather than zeros, then you might try doing this:

=IIF(Not Is Null(MyField), CCur(MyField)) as the control source for the
report's control where the data is displayed.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question