I have an "answer" table where the records look something like this.
Question 1 Agree
Question 2 Disagree
Question 3 No Opinion
I am assuming the example shows 3 records of the Answers table - otherwise you have a serious structural probem.
Define a relationship between Answers and Weighting, matching on answer.
Define a calculation field in the Answers table = Weighting::Number.
Use a summary field in Answers table to total the calculation field.