CODEWITHSUNDEEP
ms-access
Leon M
Leon M

Reputation: 13

Sum numbers if cell contains X and store in another table

So if we have two columns 'Domain' and 'Score'. There are duplicate domains with different scores. How would I add all the scores together that are from the same domain?

and furthermore, how do I then show it separately in another table?

Thanks,

Leon.

Upvotes: 0

Views: 18

Answers (1)

Tarun. P
Tarun. P

Reputation: 442

query look like this.

SELECT Domain, sum(NZ(Score,0)) as total FROM yourtable group by Domain

Upvotes: 1

Related Questions