#1
  1. No Profile Picture
    Registered User
    ASP Explorer (0 - 99 posts)

    Join Date
    Jan 2013
    Posts
    1
    Rep Power
    0

    In 2007, linking field of numerically coded survey responses with code definitions


    I am analyzing household travel survey data. There is an income question. The income field in the table contains numerically coded (1-18) reponses that represent income ranges reported by survey respondents. I have created a table that lists what numerical code represents what income range. For example, numberical code "1" represents the <$5,000 annual income range or numerical code "17" represents the $80,000-$99,000 income range. I need to link the numerically coded responses to the income range they represent and aggregate each income range to determine total and percent of households in each income range. And, finally produce a crosstab query with the income ranges in the rows and the total and percent of household in columns.

    Please advise. Thanks
  2. #2
  3. Contributing User
    ASP Adventurer (500 - 999 posts)

    Join Date
    Jun 2011
    Location
    South Jersey
    Posts
    544
    Rep Power
    59
    Sounds like you know exactly what to do. What is the question? Which part are you stuck on?

    You'll find most people don't like to answer vague questions or how do I do this whole thing type of questions. Keep your questions specific with examples and you'll have no problem getting an answer.

Similar Threads

  1. Replies: 0
    Last Post: March 4th, 2011, 10:29 AM
  2. If table has blank field, hide responses
    By jesushax in forum ASP Development
    Replies: 3
    Last Post: September 17th, 2007, 06:06 AM
  3. Replies: 1
    Last Post: August 5th, 2007, 09:18 AM
  4. Linking SQL Express 2005 Tables to MS Access 2007
    By DevAdmin in forum Development Articles
    Replies: 0
    Last Post: March 13th, 2007, 08:00 AM
  5. Linking a Yes/No Field with a Text Box Field
    By Siena in forum Microsoft Access Help
    Replies: 3
    Last Post: January 10th, 2005, 06:44 AM

IMN logo majestic logo threadwatch logo seochat tools logo