Sample Header Ad - 728x90

Querying a many to many relationship in access

0 votes
3 answers
5325 views
I have just created a many to many relationship in MS Access with three tables as shown below enter image description here AE Career Fair - Struc contains a list of companies where the company name is distinct. Office Locations - Int is a junction table containing in one column all the companies occuring in AE Career Fair - Struc, but duplicated based on the countries in which they occur. Countries contains a list of all the countries in the world. I was able to run a query for companies occuring in one particular country of interest. I would like to take this a step further and query this relationship and determine which companies are in more than one country. I cant really think of a way to do this based on how I currently have it set up. Could anyone provide indications as to how this would be done? Thanks.
Asked by user32882 (142 rep)
Aug 13, 2016, 07:01 PM
Last activity: Feb 13, 2025, 12:02 PM