I'm relatively new to the Access game but amd trying to extract some data from a healthcare database that I have created.
There is the main table with standard/simple data which has a linked table that allows multiple values to be entered. I have created queries that will count how often each individual response has been entered however I want to create a query that tells me how many records have more than one (multi)value selected.
This would mean that in our reporting we could say x% of people have this condition, x% of people have this condition, x% of people have this condition while x% of all respondents had more than one condition.
NB. The linked multivalue table has approx 20possible responses while the main table has about 1000 records.
Thanks in advance