Link to home
Create AccountLog in
Avatar of LillyC
LillyCFlag for United Kingdom of Great Britain and Northern Ireland

asked on

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

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?
ASKER CERTIFIED SOLUTION
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of LillyC

ASKER

Thanks :)