Microsoft Access Inquiry

[PowerBlue]

Hello! :)

 

Can someone help me since I'm having problems with SQL?

I have already fixed the columns as desired and originally planned.

However, I can't seem to show the population as a percentage of the total population.

 

Does anyone know how can I adapt this code below?

 

SELECT DISTINCTROW POPDATA.CITYNUM,

COUNT (*) FROM POPDATA

WHERE POPDATA.ANCNUMBER=720

GROUP BY POPDATA.CITYNUM

ORDER BY COUNT(*) DESC;

 

Thank you very much. Hoping for your kind reply. :)

[RandyL]

This is a pretty specific query related to specific programming language. You might want to run a search for SQL tutorials or forums. Sorry but I don't know SQL.