PDA

View Full Version : Distinguish data based on language.


ALH-BAR
Dec 20, 2017, 04:43 PM
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
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.