How to sum percentages per group via a query in MS Access 2010

LillyC
LillyC used Ask the Experts™
on
Hi

I'm trying to create a string statement to total a number of percentages per race. The number in each race can vary, example:

Race     Percentage    Total percentage
1            22                    68
1            30
1            16
2            50                    70
2            20
Etc

Can anyone help?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2016
Commented:
you can do a total query

select Race, Sum(Percentage) as TotalPercentage
from tableName
group by Race
LillyCDatabase Developer

Author

Commented:
Thanks :)

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial