"Not" criterion for Multiple Lines

[alcharbonneau]

Hi

I have been writing Access 2010 queries on a data base with 101 lines of data. When I do not want to retrieve data from line 09500 I add the criterion Not 09500. My question is how do I write a criterion that excludes two lines such as 09500 and 10100?

Thank you for taking the time to read/respond to this question.

Al

[mrice]

Have you tried Not In ('09500','10100').

This syntax works for other databases.

[alcharbonneau]

Bingo - Worked perfectly.

Thank you