Returning only a null value

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.....
 
D

Dale Fye

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.
 
D

Dale Fye

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.
 
J

John Spencer

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top