Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Access (https://www.askmehelpdesk.com/forumdisplay.php?f=441)
-   -   Distinguish data based on language. (https://www.askmehelpdesk.com/showthread.php?t=836168)

  • Dec 20, 2017, 04:43 PM
    ALH-BAR
    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!
  • Dec 22, 2017, 03:50 AM
    ScottGem
    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.

  • All times are GMT -7. The time now is 02:17 PM.