1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

MS Access Programming Problem

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

  1. jasper_cs30

    jasper_cs30 New Member

    Joined:
    Aug 12, 2010
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    0
    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

    Joined:
    Nov 24, 2009
    Messages:
    387
    Likes Received:
    90
    Trophy Points:
    0
    send your database in a zip file
     
  3. jasper_cs30

    jasper_cs30 New Member

    Joined:
    Aug 12, 2010
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    0
    okay. what is your email address?
     
  4. virxen

    virxen New Member

    Joined:
    Nov 24, 2009
    Messages:
    387
    Likes Received:
    90
    Trophy Points:
    0
    upload it in a free download server (rapidshare megaupload etc) and send the link
     
  5. jasper_cs30

    jasper_cs30 New Member

    Joined:
    Aug 12, 2010
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    0
    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

    Joined:
    Jul 12, 2004
    Messages:
    15,283
    Likes Received:
    364
    Trophy Points:
    83
    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

    Joined:
    Aug 12, 2010
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    0
    thank you very much! :)
     

Share This Page