Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Multiple Table Problem

Status
Not open for further replies.

carlosv13

Programmer
Joined
Jun 30, 2003
Messages
2
Location
US
Hi all,

I have a table that is created using a make table query ,"filter_table", upon the user selecting certain info. I then want to take this newly created table and compare it to a query, "fill_list", that is populating a listbox. I want to ommit any names that were in the "filter_table" from the "fill_list" query. I have tried several queries and cannot get any of them to work. I can get the list to display the values that are equal to each other, but I can't get it to do the opposite. Any help would be much appreciated.
 
The query that is working improperly is this:

SELECT DISTINCT application.Application_Name
FROM application, filter_table
WHERE (((application.Application_Name)<>[filter_table]![Application_Name])));

It takes out the names I want it to take out but it is giving me too many application names back.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top