No results from this query

[crowegreg]

I have two tables:


ITS_Operations_SVP
ITS_VP_List

The records within ITS_VP_List are also within ITS_Operations_SVP. I'm trying to write a query that displays the records within ITS_Operations_SVP that are not within ITS_VP_List.

Here's what I have
SELECT DISTINCT ITS_Operations_SVP.[VP Name]
FROM ITS_Operations_SVP LEFT JOIN ITS_VP_List ON ITS_Operations_SVP.[VP Name] = ITS_VP_List.[VP Name]
WHERE (((ITS_Operations_SVP.[VP Name])<>[ITS_VP_List]![VP Name]))
ORDER BY ITS_Operations_SVP.[VP Name];

This produces no records. What am I doing wrong?

[ssanfu]

There is a wizard to create this query. It is called the "Unmatched query".

I used the wizard to create an unmatched query on two different tables:

SELECT [Account].[ACCOUNT], [Account].[ID], [Account].[Insp_Date], [Account].[StandAlone], [Account].[AccountBalance]
FROM Account LEFT JOIN AccountNums ON [Account].[ID] = [AccountNums].[id]
WHERE ([AccountNums].[id] Is Null);

Try changingthe WHERE clause in your query to :

WHERE ITS_VP_List![VP Name] IS NULL

[crowegreg]

Thanks. I should have figured that one out.