<div>
<div class="content wysiwyg-content">
Hi <br />
<br />
I'm trying to create a string statement to total a number of percentages per race. The number in each race can vary, example:<br />
<br />
Race &nbsp; &nbsp; Percentage &nbsp; &nbsp;Total percentage<br />
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;22 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;68<br />
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;30<br />
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;16<br />
2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;50 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;70<br />
2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;20<br />
Etc<br />
<br />
Can anyone help?
</div>
</div>


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?

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

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.