Adapting a fragment code

[accesscurrymoodle]

Hey I need some help! I want to adapt this program code in a database regarding the population of specific ethnicities in US Cities. I want to adapt the program code in a way that I can get the following



1) 2 columns: __ethnicity__ population and total population
2) __Ethnicity__ as a percentage of the total population

The database file looks like this:


The code I'm planning to use is right below:

[NTC]

Access offers the AggregateQuery as an embedded feature. In your textbook you will find examples of how to use this and should offer you exactly what you seek.