Complicated unmatched query - help!

[scott0_1]

Hi All,



Instead of giving you the complicated setup I have, I'll let you know what I'm trying to accomplish with smaller, fake tables.

I've got tblEmployee, tblCourseCatalogue and tblIndividualLearning. tblEmployee is a table with all employees and it's primary key is ID. tblCourseCatalogue is a table with all courses and employee can take and it's primary key is ID. tblIndividualLearning is a table that links the others. It's primary key is ID, with EmpID, CourseID and DateCompleted.

I've got a query that lists what employees have completed a specific course. I now want to use that query as a subquery to list those that have not taken that specific course.

I know the easy way is to create two separate saved queries, but like I said, the real thing is a little more complicated. I'm running the queries through VBA so I can use some variables to add in some custom search parameters.

What I would like to know is how to write the whole SQL statement. SQL is not my forte!

If someone could give me an example with the simple structure above, I will be able to pick through it and modify it for my needs.

Thanks for the help as always!

Scott

[isladogs]

Suggest you read this parallel thread https://www.accessforums.net/showthread.php?t=76399
As you are referring to 3 tables, yours may be a little more complicated .
However as you aren't confident in using code, build your query using the unmatched query wizard.
Check that it does what you want then change to SQL view.
Copy the SQL statement into your code and you may not need to save any queries

If it helps use my SQL to VBA and back again utility to convert for use in your VBA