How do I use MS Access SQL to make a not equal condition?

Viewed 2807

I currently want everything that is not 'Apple' or 'Banana' under column 'Fruits'.

My current code is:

SELECT *
FROM [MyTable]
WHERE [MyTable].[Fruits] <> "Apple" OR [MyTable].[Fruits]<>'Banana'
;

Yet it still gives me Banana and Apple values. Any advice?

1 Answers
Related