does not equal

[mugman17]

I have a query where I need to look up the term as long as it does not equal some of the entries.

ie. it cannot equal Summer 2003, Summer 2004, Summer 2005, Winter 2003, Winter 2004 and Winter 2005...but it can equal everything else.

I tried this:

<>"Summer 2003" or "Summer 2004"...etc.

It takes out the first one, but not the rest. Please help.

 

[Jon K]

<>"Summer 2003" And <>"Summer 2004" ... etc

You can also use:
not in ("Summer 2003","Summer 2004" ... etc)


Edit:
Thanks, glynch. etc. should end with a full stop.

 

[glynch]

<>"Summer 2003" and <> "Summer 2004"...etc.