Adapting a fragment code

K

KathC

Joined
Aug 23, 2010
Messages
2
Reaction score
0
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:

popdata.jpg


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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adapting a fragment code 0
macros or formulas not sure 6
Automating a computation process 3
Having problems w/ Solver code 3
Filling a combobox from MTGC with data from a datatable 3
population percentages and ranks 5
summing population by zip and by county together 3
Random to appear on a report 4

Top