Search for specific dates

[natalia]

I am currently creating a database for my alevel coursework,



I wanted to know how I could search for a customer who ordered a turkey last year but who has not ordered this year.

How could I set up this query?

I have a field which is Date ordered, in the format dd/mm/yyyy.
I was not sure how I could specifically search for the answer.

Thanks for your time

[weekend00]

SELECT a.customer FROM Orders AS a LEFT JOIN (select customer from orders WHERE stuff="Turkey" AND Year([orderdate])=2010) AS b ON a.customer = b.customer
WHERE (((a.stuff)="Turkey") AND ((Year([a].[orderdate]))=2009) AND ((b.customer) Is Null));

[natalia]

SELECT a.customer FROM Orders AS a LEFT JOIN (select customer from orders WHERE stuff="Turkey" AND Year([orderdate])=2010) AS b ON a.customer = b.customer
WHERE (((a.stuff)="Turkey") AND ((Year([a].[orderdate]))=2009) AND ((b.customer) Is Null));

Thanks for your help!!