Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have a table with numbers from 0-5, under different field names (Score1, Score2 etc. all the way to Score50) that need to be summed at the last column of that same row. Each row represents a different client with its own info.

Is it possible and if it is, some help would be nice.

share|improve this question
2  
Unless Access has a limitation on the number of columns you can + together in the query, I don't see a real problem here - except your data layout: you should normalize your table a bit more, with a column for "client_id" and only one score per row. –  Mat Sep 16 '13 at 10:01
    
The problem is Access wont let me calculate the sum of values in the same row. Was just wondering if thats possible at all. I'm pretty new to Access so I don't know how to mark new Clients with their own ID. –  Ville Koivunen Sep 16 '13 at 10:33
add comment

2 Answers

select *, Score1 + Score2 + ... + Score50 as TotalScore
from table

You can fill in the rest of the scores :-)

By the way, you really should normalise this table. It will make your life much easier.

share|improve this answer
    
Sure I could and would if I had any idea how :D I'm just pretty new to this Access stuff still. –  Ville Koivunen Sep 21 '13 at 22:32
    
No worries, but did my query above work out for you? –  Yawar Sep 21 '13 at 23:35
    
Yes it did. Thank you :) –  Ville Koivunen Sep 22 '13 at 9:34
    
@VilleKoivunen - then an accept would be fair, right? :-) –  Yawar Sep 23 '13 at 0:09
add comment

You can create a view with same Query Defined by Yawar select , Score1 + Score2 + ... + Score50 as Total Score from table*strong text**

and you do not need to write same query again and again.

Regards, Sam

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.