Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Printing what is missing..

Status
Not open for further replies.

rlporter

Programmer
Sep 7, 2003
24
US
I have an employee table and a training records table. Not everyone has been to training, so they have no records in the training table. I would like to print a list of anyone in the employee table that is missing from the training table. Can this be done in CR 9?

Thanks for any help.

rlporter
 

Create an SQL Command something like this.
SELECT * FROM EMPLOYEE WHERE EMPLOYEE_ID NOT IN (SELECT EMPLOYEE_ID FROM TRAINING)
 
Link the tables with a left join from the employees table to the training table, using something like the employee ID field that appears in each. Place {employee.name} in the details section. Then go to report->edit selection formula->record and enter:

isnull({training.employeeID})

Be sure not to add any other selection criteria that use fields in the training table.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top