Adding Fields

[jlclark4]

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?

[mbar]

I'm not an expert but I'll attempt to help...

it should only add the fields for each record. are you grouping these records and is that field which contains the expression set to "sum"?

[jlclark4]

I tried that and it gives a number that does not make since. The returned number should be no more then that listed in the QualityPoints Field. See the attached screenshots

[kennejd]

I can only see part of the query so it's difficult to tell what's wrong. It could be a matter of changing some grouping.....or possibly your table isn't set up right.