Not Criteria

  • Thread starter Thread starter Kerry Purdy
  • Start date Start date
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

System Resource Exceeded/Query Too Complex 4
Sort across a table 2
Is it possible to use a function to set query criteria 1
nested iif function 4
Only where a specific feild is unique. 11
DSum update query with multiple fields 0
Select ONE record 1
Combining Two Queries 1

Back
Top