Multiple Table Problem

[carlosv13]

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.

 

[carlosv13]

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.