Search results

This is similar to what I want. Maybe it's more clear if I make up some data. tblCompany CompanyID strCompanyName 1 Bob's Company 2 Sarah's Company tblCounty CountyID strCountyName 1 Jefferson 2 Washington 3 Lincoln 4 Hancock 5 Nixon tblAssignCounty AssignCountyID CompanyID CountyID 1 1 1 2...

Thank you for your response. I'm probably not explaining this well. I believe I have the relationships correct, as my report does list the correct counties for eacy company. The issue is that the counties are each listed on their own line since they are each their own record. I'd like to...

I'd like to have output like this: Company1Name ContactInfo1 County1, County2, County3, County4 Company2Name ContactInfo2 County5, County6 Company3Name ContactInfo3 County7 etc What I have so far looks more like this: Company1Name ContactInfo1 County1...