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 Active Member

    Joined:
    Nov 24, 2009
    Messages:
    387
    Likes Received:
    90
    Trophy Points:
    28
    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 Active Member

    Joined:
    Nov 24, 2009
    Messages:
    387
    Likes Received:
    90
    Trophy Points:
    28
    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,375
    Likes Received:
    388
    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

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice