Need Join help


M

menken.john

I am using Access 2010 and if someone could help me with this query I wouldbe eternally grateful. I have two tables. The first table shown below in Figure 1 is a complete list of everyone in the company (fictionalized and abreviated). My second table called "Completes" and denoted by Fig 2 below isa list of employees and the courses that they have completed. This is pulled from our company Learning Management system and as you can see, an employee may be listed more than once. With both tables imported into Access I want to produce a result set that shows a result set like Fig 2 with one additional item. For anyone that has not taken a course, I would like them listed at the bottom of the result set with blanks for Course name and completion status. What I'm hoping for is shown in Fig 3. Thank you very much and sorry for the poorly formatted data below.

Fig 1. AllEmployees table

First Last Gnumber
Alex Anderson 90
Brooke Brown 78
Carol Clark 16
David Drew 98
Erin Eisley 76
Felicia Ford 77
Gretta Grant 26
Zach Zubov 18


Fig 2. Completes table

First Last Gnumber CourseName Completion Status
Alex Anderson 90 Intro to Blah Blah Complete
Brooke Brown 78 Advanced Hoo Hah Complete
Carol Clark 16 Writing for beginners Complete
David Drew 98 Intro to Blah Blah Complete
Alex Anderson 90 Intermediate widgets Complete
Alex Anderson 90 Beginning robotics Complete


Fig 3. The result set I'm hoping for

First Last Gnumber CourseName Completion Status
Alex Anderson 90 Intro to Blah Blah Complete
Brooke Brown 78 Advanced Hoo Hah Complete
Carol Clark 16 Writing for beginners Complete
David Drew 98 Intro to Blah Blah Complete
Alex Anderson 90 Intermediate widgets Complete
Alex Anderson 90 Beginning robotics Complete
Erin Eisley 76
Felicia Ford 77
Gretta Grant 26
Zach Zubov 18
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top