By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,847 Members | 3,102 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,847 IT Pros & Developers. It's quick & easy.

Decimal places in calculated fields

P: 1
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
May 13 '18 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 15k+
P: 31,307
even though the decimal place setting is 1.
What is this "the decimal place setting" you're referring to? Individual controls and fields have such settings - individually. This isn't something shared across a database. Some items inherit properties from other items to be sure, but you've given no indication in your question to indicate this might be so.

Now, asking your first question is always going to be a little hit & miss. I understand that. That doesn't help me understand what you're asking about though.

Let's start with trying to determine some basic and critical facts. Are you asking about fields that are part of a table, or fields that are in a query? Both can have Format properties. Unfortunately, some calculations make it hard for Access to decide exactly what it's working with so it sometimes doesn't recognise whether to show the property for decimal places.

Once we know what you're trying to do we can certainly lead you in the right direction.
May 13 '18 #2

Post your reply

Sign in to post your reply or Sign up for a free account.