Average of an unbounded field in a report

[George]

Good morning.



In a report there is an unbounded field (Text29) that obtains its data by adding 2 fields [CourseMark] and [ExamMark].

An unbounded field (Text58) is added to the header to receive/calculate the average of the Text29 field.

The code entered to get the average is: Ave ([Text29])

The results is a display of an "Enter parameter Value" text box.

How can I be help please?

[pbaldy]

I don't think you can do that, but you should be able to average the combination:

=Avg(CourseMark + ExamMark)

That's untested, but give it a try.

[George]

I would rephrase my question.

How can the average of the values in a single field be assertained in a report when that field is the result of calculations of other fields?


George

[pbaldy]

Let me rephrase the answer:

http://support.microsoft.com/kb/207763

Sum is no different than Avg.

[George]

Thanks. I now understand.

[pbaldy]

No problem.