Querying a many to many relationship in access
I didn't really do a lot with MS Access, but you can try something like this, assuming that company.id is primary key and country.id is primary key and the corresponding tables are related to locations through company_id and country_id, respectively:

SELECT company.name, country.name
FROM locations
LEFT JOIN company 
ON company.id = locations.company_id
LEFT JOIN country 
ON country.id = locations.country_id
GROUP BY company.name 
HAVING count(locations.country_id) &gt; 1