Query - Determine what is missing

[Pass-the-reality]

On my form I have 5 fields (analyst, Contracting, KMSI, GAMS and MAPD). All 5
fields are pulled from the same table. On the form I will type in an analyst
name and then under the 4 remaning fields, I will insert a date if the
analyst has taken that course. I want to run a query that will tell me the
analyst name and which courses he still needs to take. For example if Bob
was entered in as the name and there are dates for Contracting and KMSI, I
would want the report/query to tell me that Bob still needs to take GAMS and
MAPD.

 

[Clif McIrvin]

On my form I have 5 fields (analyst, Contracting, KMSI, GAMS and
MAPD). All 5
fields are pulled from the same table. On the form I will type in an
analyst
name and then under the 4 remaning fields, I will insert a date if the
analyst has taken that course. I want to run a query that will tell
me the
analyst name and which courses he still needs to take. For example if
Bob
was entered in as the name and there are dates for Contracting and
KMSI, I
would want the report/query to tell me that Bob still needs to take
GAMS and
MAPD.

In the query design grid set the criteria for Contracting to IsNull,
then drop one line ("or") and set KMSI to IsNull, drop one line, set
GAMS to IsNull, drop one more line and set MAPD to IsNull.