Ask Experts Questions for FREE Help !
Ask
    ALH-BAR's Avatar
    ALH-BAR Posts: 1, Reputation: 1
    New Member
     
    #1

    Dec 20, 2017, 04:43 PM
    Distinguish data based on language.
    Hey, I'm relatively new to using MS Access and am a little stumped on how to accomplish my next step.
    I have created a database that tracks the answers to a survey. The survey is available in both English and Spanish. As of right now, about 25% of the completed surveys have been returned Spanish. Not every question is answered on every survey, so the statistics for each question vary wildly.
    I have created reports that give statistics for each question; however, I now want to break that down by language - which is tracked with a yes/no box.
    I'm sure the answer is easy-peasy, but I would appreciate assistance pointing me in the right direction.
    Thanks!
    ScottGem's Avatar
    ScottGem Posts: 64,970, Reputation: 6056
    Computer Expert and Renaissance Man
     
    #2

    Dec 22, 2017, 03:50 AM
    What is the structure of your database? A survey database requires a very specific structure. Something like this:

    TblQuestions: QuestionID (PK AutoNumber), Question
    TblRespondent: RespondentID (PK AutoNumber), names, other details about respondent
    TblResponse: ResponseID (PK AutoNumber), RespondentID (FK), ResponseDate, ResponseLanguage
    TblAnswer: AnswerID (PK AutoNumber), ResponseID (FK), QuestionID (FK), Answer

    Without knowing your structure, I can't advise further.

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Based on the data below, what is the amount of working capital? [ 0 Answers ]

Accounts payable $30,000 Accounts receiveable $65,000 Accrued liabilities 7,000 Cash 20,000 Intangible assets 40,000 Inventory 72,000 Long-term investments 100,000 Long-term liabilities 75,000 Marketable securities 36,000 Notes payable (short-term) 20,000

Based on Internal Revenue Service rules, what criteria distinguish a consultant fr [ 2 Answers ]

Based on Internal Revenue Service rules, what criteria distinguish a consultant from an employee?

Excel - aligning data based on a common value. [ 7 Answers ]

I have 2 lists of data. List A contains 2 columns - Lead ID (column A) & Email ID (column B). This list contains 3,175 rows. List B contains 2 columns - Email ID (column A) & Email Address (column B). This list only contains 3,085 rows. I need to match up the Lead ID with the Email...

Web Based Games and Data Usage [ 3 Answers ]

Hello :) My question is about data usage on broadband.. My dad pays for our broadband and we had 12 giga bites of downloads each month, we kept going over this limit, so he changed to a plan that allows 20 giga bites per month. Now, we are close to reaching this limit and he is getting very...


View more questions Search