MS Access Programming Problem

jasper_cs30's Avatar, Join Date: Aug 2010
Newbie Member
so our computer science professor to create a database for the population of Filipinos in the USA. Now, he's asking us to complete the code below, to show:
a) Two columns - the Filipino Population and the Total Population
b) The Filipino Population as a percentage of the total population

SELECT DISTINCTROW POPDATA. CITYNUM,
COUNT (*) FROM POPDATA
WHERE POPDATA. ANCNUMBER=720
GROUP BY POPDATA. CITYNUM
ORDER BY COUNT (*) DESC;

Can anyone please explain how to solve this? Thank you!
0
virxen's Avatar, Join Date: Nov 2009
Pro contributor
send your database in a zip file
0
jasper_cs30's Avatar, Join Date: Aug 2010
Newbie Member
okay. what is your email address?
0
virxen's Avatar, Join Date: Nov 2009
Pro contributor
Quote:
Originally Posted by jasper_cs30 View Post
okay. what is your email address?
upload it in a free download server (rapidshare megaupload etc) and send the link
0
jasper_cs30's Avatar, Join Date: Aug 2010
Newbie Member
here's the first part of our activity. the database files are there.
sorry i dont know why i cant post links, it always says contact administrator too much links
so here it is
http://sendspace.com/file/5693nb
0
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
The reason you cannot post links is you have too few posts and this is done to stop spam. I have linked to your file as of now and get more posts and this message will go away.
0
jasper_cs30's Avatar, Join Date: Aug 2010
Newbie Member
thank you very much!