Great community. Great ideas.

Welcome to ASP/Free, a community dedicated to helping beginners and professionals alike in improving their knowledge of Microsoft's development and administration technologies. Sign up today to gain access to the combined insight of tens of thousands of members.

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

Results 1 to 2 of 2
Share This Thread →
  1. #1
    shahnaz10 is offline Registered User
    Join Date
    Jan 2013
    Rep Power

    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
    meratigoerr's Avatar
    meratigoerr is offline Contributing User
    Join Date
    Jun 2011
    South Jersey
    Rep Power
    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.

Share This Thread →

Become Part of This Conversation

Join NowFor Free!

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

ASP Free Advertisers and Affiliates