HELPME

[Guest_imported]

If this is a repeat of a previous post please forgive me

I have 3 tables # denotes KEY

TBL_Names
Lastname firstname StuID# etc…

TBL_Topic
TopicID# topic subject etc…

TBL_Covered
Recid# StuID TopicID

I have a form who's source is set to the TBL_Topic.
In one list box I am easily able to show who has covered which topic by doing a query on TBL_covered.
In the other list box I want to show who has not covered the topic.
I need assistance with the SQL that will show me who has not covered the topic. I have tried various joins with out result.
Any assistance would be appreciated

 

[Guest_imported]

I got it to work but if some one can give me a more elegant solution I would appreciate it.
I saved my original sql from the first listbox as a query then did an unmatched query based on the first query and TBL_names. Now I just refer to the two querys as the sources for my listboxes.
I would prefer to do it in one statement rather then 2 querys.

 

[IdoMillet]

Do a Select X, Y, Z ... Where StuID# NOT IN (Select StuID FROM.. WHERE....)

hth,
- Ido

 

[Guest_imported]

Thanks Ido, got it to work. Not sure where my head was but it sure was "dark" and "smelly" there.