Hi,
I am running a query using the following two tables:
Tbl_Company (contains names of companies)
Tbl_Contacts (contains names of people employed at one of the companies in the "Tbl_Company" table)
The Join Properties are such that I am showing all records from "Tbl_Company" and only those records from "Tbl_Contact" where the joined fields are equal (this is intentional because I want to see all companies listed, regardless of if they have a contact). However, for the companies that do have a contact, I want to add a criteria to only show active employees (a yes/no field data type) - but adding this criteria to the "Tbl_Contacts" table is preventing all the companies to show up in the query. Is there any way I can show all companies regardless of if they have a contact, but have a criteria assigned to the contact if the companies does has a contact?
Thanks