Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2010
    Posts
    1

    Unanswered: help really needed.

    how to do this?

    there's this table that i was able to convert from numbers to sensible information. the first column includes the id number, the second column is for the city in the united states, and the third column is for the nationalities (and some have info like 'not reported'.)

    all i need to do is use the code but how?


    how to adapt the fragment of 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;

  2. #2
    Join Date
    Sep 2010
    Posts
    2

    Help for MS Access homework: creating a sorted list

    For our homework in our Computer science class, we were tasked to research by asking expert advice on database forums. We were first asked to download Census data to be analyzed using Microsoft Access. The data contained facts about 1% all people living in large US Cities at the time on the last US Census in the year 2000. The file gave the name of the city and the racial/ethnic ancestry of the person concerned.

    I was able to achieve the objectives of the first task by illustrating the ff terms: fields, records, key fields, primary keys, foreign keys, relationship, and SQL.

    To finish the task, we need to create a sorted list showing the number of Filipinos living in each city (with the cities with the largest number of Filipinos at the top).

    I am not sure how to do this exactly. I need your advice on how to adapt the fragment of 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

    The code is:

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

    Thank you so much! I would really appreciate your advice on this.

  3. #3
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Since you're both posting the same question, for your first posts, after joining on the same day, using oddly identical verbiage in certain areas of your posts... I decided to merge the two.

    Perhaps you can get together and solve it as a team.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  4. #4
    Join Date
    Sep 2010
    Posts
    2
    That's because we are probably under the same teacher, although we both still need help.

    I am really clueless with this task.

  5. #5
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    And kudos to deanemiguel for being upfront about this being a class work assignment!

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  6. #6
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Please ask your professor or their assitant to contact me. I'd like to discuss this assignment with them so that I can understand what they want you to learn from it.

    With a "normal" assignment it is easy to understand what the instructor's intentions are, but this is unique. Don't be concerned about asking them to contact me, I'm certain that they are prepared for that request and are expecting it.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •