Adding database values 1

[schase]

Access 2000

I am creating a survey results page. I need to add the rows in table cells together - then divide by the number of records to get an average "score"

For example, tblServiceSurvey, fields Q1A,Q1B,Q1C,Q2A,Q2B.... And so on.

How would I go about doing this?

Thank you in advance

 

[rico14d]

Could this SQL Query work..

select avg(Q1 + Q2 + Q3 etc)
from tblServiceSurvey

 

[schase]

Slight mod works great!

Doing
SELECT avg(Q1A),avg(Q1B) etc.

Thank you!