I have just created a many to many relationship in MS Access with three tables as shown below
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
Last activity: Feb 13, 2025, 12:02 PM