Hey
I am trying to add up points possible verus points earned in a query. I have a query set up that calculates the points possible for each tab in my form/table. Below is an example of the feilds I am trying to add together.
I have a table with feilds 2a, comment (2a), D2a, Q2a, 2b, comment (2b), Q2b, 2c, comment (2c), Q2c, etc.
The beginning number represents what tab the questions were in (this form is used for quality and has questions and answer on it and certain questions are weighted different)
I tried to use a Expression in the Query
Quality: [Q2a]+[Q2b]... but it adds all the rows and fields together which I do not want it to do. I only want it to add the points earned across that row.
Any Ideas?