Returning only a null value

  • Thread starter Thread starter Lisa
  • Start date Start date
L

Lisa

I am trying to build a query that will only return null values - it's a
training roster and I only want to see the people who have not completed any
of the 12 mandatory training classes and I only want to see the course that
they need.

It's making my head hurt.....
 
It would make it infinitely easier if you would explain your table structure
for us!

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.
 
Is it Ray?

I think it is probably more complicated than that.

My guess is that she either has a "spreadsheet" with 12 columns for the 12
required courses, or (if we are lucky) has a well normalized training table
(People_ID, Training_ID, CompletedDate). In either case, I don't think it
will be as simple as a single "IS NULL"

--
Dale

email address is invalid
Please reply to newsgroup only.
 
Also, the request is a bit ambiguous.

"I only want to see the people who have not completed any of the 12 mandatory
training classes and I only want to see the course that they need"

"...see people that have not completed any of the 12 ..."
Does this mean that none of the courses have been completed by the individual
or does it mean show me the classes this individual has not completed?

....I only want to see the course that they need...
I assume from this that the poster wants to see any course that the individual
has not completed (and not just one - although that is what it says).

Without knowing the table structure and exactly what the poster wants, I think
this one goes to the dead-request file.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
 
Back
Top