I have a database with 8 calculated fields. In each calculated field, I would like to have some values with 0 decimal places, while others would have 1 place, based on the values in the records that make up the calculation. It seems I've been able to address the whole number issue by having all the calculated fields set at Result Type = single, the Format = General Number, and Decimal Place = 1. This seems to automate the values, such that whole numbers show up in the calculated fields in Tables, Queries and Report with no decimal places.
However, this also results in record values that have 1 decimal place in the regular fields showing up with many decimal places in the calculated fields, even though the decimal place setting is 1. Note: this happens primarily in calculated fields that are based on other calculated fields, if that makes difference.
Is there a setting combination for a calculated field that addresses both needs? TIA