MS Access Compound Query
Posted on 2014-03-16
Within an MS Access database, I need to filter for unique values in a single table and then produce a count for how many times each of those unique values appeared in the table.
The end goal is a single form in datasheet view that lists each unique value, its current record count, and the target sample size. I can then apply the appropriate conditional formatting.
I have two tables.
"table_questions" simply lists all the various questions ('question') in a survey and a number ('sample_size') representing the ideal sample size
"table_reponses" recorded responses to each survey question. The two columns are 'question' and "response'
So basically, I want to create a form in datasheet view that lists the unique questions in the "table_responses" table, count and report each time that question was in the table, and compare that number to the "sample_size" using the "question" as the primary key.