monophoto

I am constructing a database in which each record will include several numeric fields. I want to create a report that shows the average of those numeric fields. Some of the fields may be null, so I anticipate using the AVG function to calculate the average since that function ignores null fields. The expression that I have tried to incorporate into the 'control source' in the rerport is "=Avg([Score 1]+[Score 2]+[Score 3]+[Score 4])" but that isn't working - it doesn't return a value. What am I doing wrong?

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.