Multiple Null Values - Must be a simple Fix

[midgeamac]

I haven't used access in about 10+ years, so my skills are a little rusty at best.


I have been attempting to make a simple (or it seems like it should be) Query to tell me what meetings our employees have not attended. I have all of the employees and meetings they have attending in one table and the full list of meetings in another with related fields.
What do I need to do to generate a Query (eventually ending in a report searchable by individual employee) that can do this? It feels like it should be sooo easy but I am over thinking it.

Thank you In advance

Here is the table that has the list of meetings attended.

Sample of Employee's Listing
ID1	Employee	Safety_Meeting	Week	Year_of_Attendance
11	asprin	Foot Protection/ Heat Stress	27	2013
1095	asprin	Hazard Material Handling	45	2012
12	asprin	Line-mans Gear	26	2013
13	asprin	Managing Stress	11	2013
23	Allspice	Winter Driving I	2	2013
24	Allspice	Winter Driving II	3	2013
25	Basil	Aerial Baskets	22	2013
48	Basil	Working With New Employees	28	2013
49	Bassett	Aerial Bucket Inspection	21	2013
1116	Birch	High Hazard Locations	34	2012

And Here is the sample table that includes the full listing of meetings.

Safety Meeting	Week
Aerial Baskets	22
Aerial Bucket Inspection	21
Aerial Bucket Use	20
Aerial Safety Techniques	23
Attitude for Safety	1
Back Safety	48
Basic Electrical Safety	7

[June7]

I assume you have a table of all employees? Do a query with Employees and Meetings tables, just pull in employeeID and trainingID. Since there is no join clause, every employee will join to every meeting, resulting in all possible combinations of employee/meeting (cartesian join).

Now build query with query of meetings attended and cartesian query, join on the employeeID and meetingID, join type "Include all records from {cartesian query} ...". The fields from meetings attended will be null where there is no match to the cartesian query.