Hey guys, this is my first post.
I have a table with over 20k lines and 80+ columns containing survey results in the form of surveyID vs questions, as such:
Q1 Q2 Q3
survey1 2 3 4
survey2 1 3 2
....
My objective is to match the numbers with their real values, i.e., the answers from the survey if they refer to a demographic question or a percentage if they refer to a "degree" of satisfaction.
My questions are:
1. Is it possible to analyze a table in this matrix form in Access?
2. If so, in what format does the second table have to be and what are the relationships with the values?
What I did in Excel was an Index(Match formula but it's become too slow...
Thanks in advance
I have a table with over 20k lines and 80+ columns containing survey results in the form of surveyID vs questions, as such:
Q1 Q2 Q3
survey1 2 3 4
survey2 1 3 2
....
My objective is to match the numbers with their real values, i.e., the answers from the survey if they refer to a demographic question or a percentage if they refer to a "degree" of satisfaction.
My questions are:
1. Is it possible to analyze a table in this matrix form in Access?
2. If so, in what format does the second table have to be and what are the relationships with the values?
What I did in Excel was an Index(Match formula but it's become too slow...
Thanks in advance