Go4Expert

Go4Expert (http://www.go4expert.com/)
-   Programming (http://www.go4expert.com/forums/programming-forum/)
-   -   MS Access Programming Problem (http://www.go4expert.com/forums/ms-access-programming-t22998/)

jasper_cs30 12Aug2010 16:16

MS Access Programming Problem
 
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!

virxen 13Aug2010 12:01

Re: MS Access Programming Problem
 
send your database in a zip file

jasper_cs30 14Aug2010 14:41

Re: MS Access Programming Problem
 
okay. what is your email address?

virxen 15Aug2010 04:46

Re: MS Access Programming Problem
 
Quote:

Originally Posted by jasper_cs30 (Post 71517)
okay. what is your email address?

upload it in a free download server (rapidshare megaupload etc) and send the link

jasper_cs30 15Aug2010 10:30

Re: MS Access Programming Problem
 
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

shabbir 15Aug2010 11:21

Re: MS Access Programming Problem
 
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.

jasper_cs30 15Aug2010 13:16

Re: MS Access Programming Problem
 
thank you very much! :)


All times are GMT +5.5. The time now is 12:44.