Calculated scores (1 Viewer)

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.

What are the data types? The result indicates they are text, or being seen as such. You could get around it by wrapping each in CInt(), but I'd fix it at the source.

Thanks for your reply. I deleted the info and copy and pasted the same info in and it started working as it should.

Curious, but glad you got it working.