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?
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!