Recent content by Tiki75

Thankyou Bilbo, I am going to modify what you have sent to fit into an Access query. I'll let you know what happened. Question: in Access there is a selection for "Select Query" If I put the edited sql code in that window will it work also. Thank you so much.

The answer table is laid out 21 questions 1 column for each answer plus other columns for userId

Hi Bilbo, thanks for the help C1, C2, C3 are the columns I would create in the query to list the answers for the calculations I would need. I was trying to seperate the calculations in such a way as to have the count done first. I just realized that I overlapped the questions, thanks for...

Please help, I am new to the forum and hope my question makes some sense. I created a table which has a total of 21 questions each question choices are 0, 1, 2, 3. So say 5 people filled out these question entering either 0-3 for each question. for question Q1-14: C1: Count only the questions...