Query criteria in linked table

[kjlogue]

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

[June7]

Please clarify what you mean by 'multi-value'. "records have more than one (multi)value" sounds like you are using multi-value field. I REFUSE to use multi-value field. Makes query harder.

Or did you mean "people have more than one value", meaning multiple condition records for each person?

[orange]

Please show us your table structure.