jiblankman
Registered User.
- Local time
- Today, 12:06
- Joined
- May 27, 2008
- Messages
- 43
First, I am new to Microsoft Access, and am using Access 2000. Now that the disclaimer is out of the way, I need to create a report that combines information from two tables.
The first table contains:
Customer ID
Customer Name
Contact Person
Contact Address, City, State, Zip
The second table contains:
Employee Name
Employer (Customer Name and ID matching table 1)
The problem is that table 1 may have 100 companies listed, where table 2 has 15 employees from some of the companies. It is randomly generated and can theoretically contain all employees from one company with none from the others.
I need to create a report that can be sent to each of the customers regardless of whether any employees are listed in table 2. If no employees in table 2, then it will report "none." I any employees in table 2 are associated with that customer, then the report needs to list the number of employees and the names of the employees.
I am sure that this must be a relatively easy thing to do, but I cannot make it work. Any help is greatly appreciated. Thanks.
The first table contains:
Customer ID
Customer Name
Contact Person
Contact Address, City, State, Zip
The second table contains:
Employee Name
Employer (Customer Name and ID matching table 1)
The problem is that table 1 may have 100 companies listed, where table 2 has 15 employees from some of the companies. It is randomly generated and can theoretically contain all employees from one company with none from the others.
I need to create a report that can be sent to each of the customers regardless of whether any employees are listed in table 2. If no employees in table 2, then it will report "none." I any employees in table 2 are associated with that customer, then the report needs to list the number of employees and the names of the employees.
I am sure that this must be a relatively easy thing to do, but I cannot make it work. Any help is greatly appreciated. Thanks.
