steveb: Your query gives me what I need when I added this to the WHERE clause - AND (sc.SurveyNum = 1840). That might not be the most eloquent...

Thanks for the quick responses.

In the original query there are four statments that have a Count_Range value of "C". Within tblStmtChar a CharNum from tblCharacteristics can be in multiple...