Hi Stephannie, Please show us the query.  John

I am not exactly sure if the query is causing the issue or something else. How do I post a picture?  I am new to this forum.
I am following the instructions in the Employee Training/Certification Part 6 videos.  Some courses work fine but some will show up as complete when I assign the role. Very confusing.

I posted a picture of the query and results. It was working fine until I added a role to Levi, Joe, and Johnny. They have not completed the courses based on the role assigned. For some reason the query is marking it as complete or in progress. But the courses do not appear as a new record in the EmployeeXCourseT. It only appears on the query.

I discovered the possible issue but I don't know how to fix it. It looks the first person I assign the role to the courses are tied to the employee. Access is duplicating the information on other employees records who I assign the same role. I just did a test of HR103 by completing it for me. It moved the course to complete for me and it disappeared from the other employee that it was assigned but it was not added to his list of courses complete. It disappears off his record.

I'm not following. Can you walk me through the steps? Exactly what you did and what it's doing, and what it's supposed to do that it's not doing. Take me through it step by step. I'll try it in my database, and if it works fine in my database, that just means that you built something wrong. But if it's a problem with my database, then it's something that I did wrong, and I'll definitely do my best to fix it. But walk me through it step by step.

Hi Richard! Thank you for your reply. Do you want me to reply on here or email you.  I have been watching each video in the Tracking Employee Training and Certification Training Series and ran into the problem after part 6 when I created the queries to show the missing courses and created the ListBox to show the missing courses on the EmployeeF. I think it has to do with a many-to-many relationship but I can not figure out where I goofed.
I just purchased Expert Level 6 so I am hoping that helps me figure it out.

Richard please look at the picture I posted above with the EmployeeCourseStatusQ. The first employee Stephannie is HR Level 1 and has course HR101 (Complete), HR102 (Complete), HR103 (Not Complete/Missing), HR203 (Complete), and HR204 (Not Complete/Missing). Then look at Employee Joe who is also HRLevel 1. The same courses are assigned to Joe which is correct because it is the same role. However Joe did not take the courses only Stephannie completed the courses. For some reason access is copying the course status from Stephannie to the other employee Joe even though only Stephannie completed the training.  I did not enter a course completion for Joe.

Reply on here of course. I can't provide technical support via email. I get far too many emails as it is. Sorry. I'll try walking through your issue now...

I just noticed you're only on part 6. Wait until you finish the entire series because there were a couple of bugs that I fixed as we move on through the series. So if you finish the whole thing and you still have this problem, let me know.

Hi Richard! Thank you for your help! I continued watching the series. The series with the bug fixes corrected the issue with the courses. It was the bug fix with connecting the EmployeeID in the EmployeeCourseReqQ and EmployeeXCourseT then doing the inner join. Worked great! Now I can't figure out why the dates will not auto populate when I change the status from InProgress to Complete.  I changed the VBA coding as described in the video but it is still not working. I will continue to watch the videos and check the coding again.

Keep watching. If you still encounter problems after you finish the series, let me know. Glad you got that one figured out.