How do I work out the average of two columns? Microsoft Access

Question

I'm currently making a report on Microsoft Access 2013. I've created a query first and then selected the appropriate tables and fields.

The last two fields of my current query are:

CourseworkMarks

Examination Marks

Both fields contains a number between 1-100. But I want to calculate the average of both fields.

I've included an image for this:

Thanks.

score 1 · Accepted Answer · answered Mar 20 '16 at 15:56

1

That would be (in the GUI designer):

AverageMarks: (CourseworkMarks+ExaminationMarks)/2

answered Mar 20 '16 at 15:56

Gustav

I tried your answer but its asking me for a parameter value? – Matt Mar 20 '16 at 16:07
@jon are the last two columns calculations in this query? Or are they aliases? Substitute aliases for absolute references (whatever the calculation is, retype into this expression in place of the field names). That's the most common cause of the parameter value issue. – MoondogsMaDawg Mar 20 '16 at 18:18
Yes, you have probably misspelled a field name. – Gustav Mar 20 '16 at 21:29
@Gustav thanks, I've fixed it. Thank you for the help – Matt Mar 20 '16 at 21:58

1 Answers1