E
esoller
Hello, This DB is my first project and my question might be basic but never
the less it drives me bananas. I need some help to put me strait again!
I have a survey db with one table that countain all the answers to my 80
questions.
Dept/Pay statu/Service Lenght/Year/Q1/Q2/Q3/Q4.....Q80
I have a query that does an average by department for each question. with
the following query.
Avg Of Q1: Avg(left([Q1],1)) as an expression and it does work properly.(I
only need the first car of the answer)
My problem is to have the same average by department but with all my 80
questions at once.
I tried many different options but none are working.
e.g. (with only 5 questions.
Avg Of AllQ:
Avg(Nz(Left([Q1],1))+Nz(Left([Q2],1))+Nz(Left([Q3],1))+Nz(Left([Q4],1))+Nz(Left([Q5],1)))/5
Does someone has an idea that could unlock my brain? Thank you
Esoll
the less it drives me bananas. I need some help to put me strait again!
I have a survey db with one table that countain all the answers to my 80
questions.
Dept/Pay statu/Service Lenght/Year/Q1/Q2/Q3/Q4.....Q80
I have a query that does an average by department for each question. with
the following query.
Avg Of Q1: Avg(left([Q1],1)) as an expression and it does work properly.(I
only need the first car of the answer)
My problem is to have the same average by department but with all my 80
questions at once.
I tried many different options but none are working.
e.g. (with only 5 questions.
Avg Of AllQ:
Avg(Nz(Left([Q1],1))+Nz(Left([Q2],1))+Nz(Left([Q3],1))+Nz(Left([Q4],1))+Nz(Left([Q5],1)))/5
Does someone has an idea that could unlock my brain? Thank you
Esoll