Access 2007 Query question - Unmatched not return results wanted

[Marie]

Hi,

I'm currently creating an Access database and am having issues with
performing 1 specific query:

The database is designed for education developers to enter and edit
course details, and for managers of specific departments to go in and
enter the 'job roles' that need to sit courses.

I need to create a query where data is returned if the department
managers have not entered any job roles for specific courses, and these
need to be ordered by department.

The tables I have are:

tblCourse:
Course_Id
Course_Title
Course_Description
Course_Objective
Course_Duration
Course_Entered_Date
Delivery_Id (fk from tblDelivery)

tblSelection:
Selection_Id
Course_Id (fk from tblCourse)
Job_role_Id (fk from tblJob_Role)
User_Id (fk from tblUser)

tblJob_Role
Job_Role_ID
Job_Role_Description
Group_ID (fk from tbl Group - references the specific department)

Can anyone please tell me how I can do this, whenever I try an
unmatched query it brings me the courses that currently don't have
ANY 'Selections' however it doesn't bring me back the ones that
don't have selections from a specific group, or do I need to change
my underlying database structure?

Thanks,

Marie

 

[Marie]

Ken,

Thank you so much! While not exactly what I was looking for it did give
me the 'missing link' that I just couldn't figure out, so I could get
what I was looking for!

Thanks Again.

Marie