adding values across several fields

[Troy Scott]

Hello, I need to create a query that will calculate the sum of several
fields of a table. An example of my table is...

Employee | Game1 | Game2 | Game3 | Game4 |
John 100 82 60 92
Joe 66 99 72 89

I hope you get the picture. I would like to keep a grand total on each
person.

Thanks!

Troy

 

[Duane Hookom]

Is it possible for you to normalize your table to
Employee Game Score
John 1 100
John 2 82
John 3 60
John 4 92
Joe 1 66
Joe 2 99
Joe 3 72
Joe 4 89
This would allow you to sum the scores by Employee.

 

[Troy Scott]

No, because Employee is my primary key. I figured a way to do it. I made a
table query then I queried the table and sum the scores. Worked like a
champ.