Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and the Yahoo Answers website is now in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
How to calculate the average of a set of fields in Microsoft Access 2003?
I am constructing an Access database to accumulate data. Each record will include four numeric fields, one or more of which may be null (empty). I will be constructing a report in which I need to display the average of the four fields for selected records, IGNORING NULL FIELDS. I can't use a simple formula because to do so would incorrectly assign a value of zero to null fields.
I am constructing an Access database to accumulate data. Each record will include four numeric fields, M1 through M4, one or more of which may be null (empty). I will be constructing a report in which I need to display the average of the four fields for selected records, IGNORING NULL FIELDS. I can't use a simple formula because to do so would incorrectly assign a value of zero to null fields. I've tried this expression, but it does not return a value.
=Avg([M 1]+[M 2]+[M 3]+[M 4])
1 Answer
- braydenLv 71 decade agoFavorite Answer
If the fields are indeed empty (ie, do not zero fill them) then when you use the AVG function it will ignore the null values.
