Qry to return list of clients who have not placed an order

[monkeysee]

Using the Northwind database as an example, how would one build a query to give a list of clients who have not placed an order in the current year?

 

[dhookom]

Try SQL like

SELECT Customers.*
FROM Customers
WHERE (((Customers.CustomerID) Not In (SELECT CustomerID FROM ORDERS WHERE OrderDate >=DateAdd("yyyy",-1,Date()))));

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]