Sum a Column

[OMS]

Hello Guys,

i've run into abit of trouble

i have a form which has check boxes on which once checked creates a score in a text box below.

Basically the user is allowed to create 6 of these forms for each user this is all setup fine the problem im having is

i need to to be able to sum the scores up for the 6 records

The forms datasource is a query.

so e.g

ID - Name - Date - Score
1 - John - 22/10/2008 - 35
2 - John - 22/11/2008 - 25
3 - John - 22/12/2008 - 23
4 - John - 22/01/2009 - 21
5 - John - 22/02/2009 - 22
6 - John - 22/03/2009 - 30

The score column needs to be sumed up so

35+25+23+21+22+30=156

The total value will then be part of another formula.

i hope i have explained that enough if not please ask!

any help would be appreciated.

 

[Bilbo_Baggins_Esq]

Is the score column sourced in the query, or is it calculated in the form or through VBA (unbound text box)?

 

[OMS]

hi this is the code which i have for the Total Score in the Query

TotalScore: ([QM_1]+[QM_2]+[QM_3]+([QM_4]*+3)+([QM_5]*+2)+([QM_6]*+2)+([QM_7]*+3)+([QM_8]*+3)+[QM_9]+([QM_10]*+3)+([QM_11]*+4)+([QM_12]*+3)+([QM_13]*+2)+([QM_14]*+5)+[QM_15])*-1