1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

MS Access Programming Problem

Discussion in 'Programming' started by jasper_cs30, Aug 12, 2010.

  1. jasper_cs30

    jasper_cs30 New 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!
     
  2. virxen

    virxen New Member

    send your database in a zip file
     
  3. jasper_cs30

    jasper_cs30 New Member

    okay. what is your email address?
     
  4. virxen

    virxen New Member

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

    jasper_cs30 New 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
     
  6. shabbir

    shabbir Administrator Staff Member

    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.
     
  7. jasper_cs30

    jasper_cs30 New Member

    thank you very much! :)
     

Share This Page