I have two prompts in prompt page first training_name and second prompt employee _id.My requirement is when end user select particular training name and employee id the report should also display the employees who did not attended the training.Any ideas please?Thanks
Let me get this straight.. You want employee's taking the training and add to this those that do not. Wouldn't that be simply ALL employee's ? :o
Barry,
Could you use the intersect/except query operations? Creating one query of all active employees and a second query of employees who took the selected training, then a result query that was the active employees who were not in the second query?
Cindy