I have a report which lists contacts by company. The report is based off of three tables:
1. Table 1 contains all the CompanyIDs which subscribe to Service A.
2. Table 2 contains all the CompanyIDs with associated Company name & state.
3. Table 3 contains all contacts by CompanyID. This table also shows which Service type a contact is associated with.
Therefore, if a CompanyID is listed on Table 1, then the company name and state are pulled from Table 2, and all contacts (associated with that company) are pulled from Table 3 if they are indicated as being associated with Service A. So far, everything is working great.
The problem arises when I have a company on Table 1, which does not have a contact associated with Service A. In this case, the Query simply does not list that company. If I remove the condition to only pull contacts associated with Service A, then the Query pulls all the contacts (no matter what service).
How can I specify the Query to list ALL Companies on Table 1 and any contacts associated with Service A on Table 3? This would produce a report listing all the companies subscribed to Service A and their contacts (if any).
-illini
1. Table 1 contains all the CompanyIDs which subscribe to Service A.
2. Table 2 contains all the CompanyIDs with associated Company name & state.
3. Table 3 contains all contacts by CompanyID. This table also shows which Service type a contact is associated with.
Therefore, if a CompanyID is listed on Table 1, then the company name and state are pulled from Table 2, and all contacts (associated with that company) are pulled from Table 3 if they are indicated as being associated with Service A. So far, everything is working great.
The problem arises when I have a company on Table 1, which does not have a contact associated with Service A. In this case, the Query simply does not list that company. If I remove the condition to only pull contacts associated with Service A, then the Query pulls all the contacts (no matter what service).
How can I specify the Query to list ALL Companies on Table 1 and any contacts associated with Service A on Table 3? This would produce a report listing all the companies subscribed to Service A and their contacts (if any).
-illini