Multiple "Not like" Query 1

[littleIdiot]

hi,

Simple one:

I have two large tables joined by a query.
I wish to EXCLUDE certain values in a specific field.

So far I have come up with the folowing:

AND ( (  EGIS_EXPORT.[Kind Cd] ) Not Like "ACQPD"   )
AND ( (  EGIS_EXPORT.[Kind Cd] ) Not Like "ACQSUP"  )
AND ( (  EGIS_EXPORT.[Kind Cd] ) Not Like "ASCCOV"  )
AND ( (  EGIS_EXPORT.[Kind Cd] ) Not Like "ASCSTT"  )

I know this is a poor way of doing this - and I have many different values to add.

How should I do it?

I do not want to delete the data, just exclude it on this query.

Many thanks,
lil'

 

[Golom]

A more convenient way may be

EGIS_EXPORT.[Kind Cd] NOT IN ('ACQPD','ACQSUP','ASCCOV','ASCSTT')

Using LIKE without a wild card character (e.g. *, _, ?, etc.) makes it equivalent to the equal (=) operator.

[small]No! No! You're not thinking ... you're only being logical.
- Neils Bohr[/small]