Displaying totals for a tickbox

[lamaar]

I have five tickboxes, ASS, AS, PR etc, which when ticked, add +1 to a value.&nbsp;&nbsp;If unticked, they -1.&nbsp;&nbsp;The default value of each tickbox is 0.&nbsp;&nbsp;I use a simple event procedure to do this (ScoreA=ScoreA+1 etc).&nbsp;&nbsp;I can display the amount of tickboxes ticked by using =Sum(Iff([#Name],1,0)) in the report footer.<br>I want to combine the total for each field into one field (ScoreTwo) and then add this to another Field, ScoreOne.<br>I have run a query using ScoreTwo: ([ScoreA]+[ScoreB]) etc but it will not display the total unless all the tickboxes are ticked.&nbsp;&nbsp;Any idead?<br>