Hello,
I have a table being used to calculate scores from a group of true/false/NA questions. Each question has a different value. The answer and the score are stored in individual lookup tables. For example, questions 1-5 have a true answer valued at 2 points, and a false answer valued at 0 points. One question of the group is allowed an NA answer whose value is null.
I cannot get my query to calculate the values. Here is what I have:
OPEN_SCORE: [Open_1]+[Open_2]+[Open_3]+Nz([Open_4],0)+[Open_5]
If four of the questions have true answers and one question is null, I should receive a score of 8. Instead, I am receiving the answer 222null2.
Any assistance is appreciated.
I have a table being used to calculate scores from a group of true/false/NA questions. Each question has a different value. The answer and the score are stored in individual lookup tables. For example, questions 1-5 have a true answer valued at 2 points, and a false answer valued at 0 points. One question of the group is allowed an NA answer whose value is null.
I cannot get my query to calculate the values. Here is what I have:
OPEN_SCORE: [Open_1]+[Open_2]+[Open_3]+Nz([Open_4],0)+[Open_5]
If four of the questions have true answers and one question is null, I should receive a score of 8. Instead, I am receiving the answer 222null2.
Any assistance is appreciated.