Not Criteria

K

Kerry Purdy

Hi,

I have a table with many numbers in a TPID field, I only want to show those
records with a TPID other than 2 or 35.

I have tried:-
Not 2 or 35
Not 35 or 2
Not 2 and 35
Not 35 and 2

it only looks at the first number after the Not.

I am sure it is a simple answer I just have a mental block - please help.

Thanks very much in advance.

Kerry
 
Top