How to show not participating employees

[barrysaab]

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

[blom0344]

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

[bi4u2]

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