Access 2000. I have created a table that lists employee names and scores that they have received on 5 tests. Each row contains an employee name, and each of the five colums contains a test score(numeric). I would like to have the fifth row calculatethe total of the five test scores(add all scores together). I tried doing this with a querey and had problems. Any help is appreciated..