access query question using not " "

[access query question using not]

need to say not with about eight items

can get it to work with one item but not more than one

how do i do this?

 

[NuBie via AccessMonster.com]

try this.

WHERE supplier_name not in ( 'IBM', 'Hewlett Packard', 'Microsoft');

 

[Kathy R.]

I noticed that Karl Dewey answered almost the same, but he used double
quotes where you used single. What is the difference?

Kathy R.