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!