I made a table with fields representing questions on a questionaire. The answers are the same for all questions --which i made combo boxes for pulling from another table where I put the answers and their corresponding scores:
table1 ---all questions are comboboxes with source as table 2
table2 -has the answers and scores
[answer]-Not sure, sure, somewhat sure, completely sure
[score] -1, 2, 3, 4
I made a form showing the all the answers, and now I want to sum all the questions together for a final score. How do I do this? Also, if I made a field on the form summing the scores, will i be able to query off it. I will want to get a query with everyone and their final score.