Consider the table:

Name Date Amount
John 1/1/2009 120
Chris 1/7/2009 45
Mary 1/2/2009 35
John 1/18/2009 100
Chris 1/1/2009 20

I need to select all records except those where name is John or Chris And date is 1/1/2009. So my query should retrieve only records 2,3 and 4. What SQL should I use?

Dear corni,

Try this query:

SELECT Table1.Name, Table1.Date, Table1.Amount, [name] & [date] AS exp1
FROM Table1
WHERE ((([name] & [date]) Not Like "John1/1/2009" And ([name] & [date]) Not Like "chris1/1/2009"));

Thanks