The Theory Of Sub-Queries?

How do I select * remaining Records of a table that don't fall true to the 2nd Select statement?

 Select * From zz_2007_Booth_Visitors

NOT IN

Select * From zz_2007_Booth_Visitors
Where [Product Interest - Actuators] Is Null
And [Product Interest - Other Actuator] Is Null
And [Product Interest - Chillers] Is Null
And [Product Interest - Other Chiller] Is Null
And [Product Interest - Electronic Products] Is Null
And [Product Interest - Other network interfaces] Is Null
And [Product Interest - Fittings] Is Null
And [Product Interest - High Vacuum] Is Null
And [Product Interest - Other high vacuum actuators] Is Null
And [Product Interest - Pick& Place and Transfer] Is Null
And [Product Interest - Teflon Products] Is Null
And [Product Interest - Training] Is Null
And [Product Interest - Valves& Manifolds] Is Null