Calculation on a calculation

[Invoice]

Hi,

This is probably a simple question, but I'm very new to Access.

Let's say I have some subject names and scores for each going horizontally as follows:

Subject Test1 Test2 Avg
English 10 8 9
Physics 9 7 8

Now, under those, in the footer, I'd like to summarize the average of each of the columns. Getting Access to do that for the first two columns is easy, but I seem to have a problem calculating the average of the third column (avg) because it was calculated.

Any tips?

 

[Matt Greatorex]

If this is all taking place on a report, you can use the names of the first two calculated fields in the source for the third.

e.g. if the first average were going into box1 and the second into box2, to get the average of these two into box3, you could use

=([Reports]![report name]![box1] + [Reports]![report name]![box2])/2