List all employees based on prompt value

[jmills]

Hi All,

Not sure why i'm struggling with this so much, however I have need of a report that prompts the user to select a value (or multiple values), and display ALL employees who have the values selected from the prompt, and those who don't have them.  Essentially, the business question is, show me which employees have taken 'Training Course A' compared to those that haven't.

for example total employees are 50, and I need to see all employees, along with the details of the training courses.  this is a relational model and the challenge i'm running into is displaying ALL employees, rather than just those filtered by the prompt.

Employee          Course                         Recieved Date        Renewal Date
Employee 1        Training course A          06/01/2012          06/01/2015
Employee 2 
...   
Employee 50      Training course A          06/01/2013          06/01/2016

what's the best way to create such a report?

[jmills]

I re-visited this with a fresh mind, and did the following:

Created two queries, one with Employees, another with Employee Training, and created an outer join between the two.

Not sure if it's the most ideal solution, however it'll work!