Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need "not like" multiple criteria string 2

Status
Not open for further replies.
hlkelly

hlkelly

Technical User
Jul 11, 2003
108
US
I can't figure it out. I have a query which needs to return all items except 1,2,3...etc.

I had Not Like "1", Or Not Like "2" but that's "too complicated to evaluated"

Suggestions?

Thanks. Heather
 
Sort by date Sort by votes
Hi Heather.

Use AND instead of OR

Not Like 1 And Not Like 2 And Not Like 3

or...

<>1 And <>2 And <>3

hope this helps you.
 
Upvote 0 Downvote
That worked...and so did choosing my items the other way...(selecting the items I want to see and not the others...DUH...Newbie here...)

Thanks!!!

Heather
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

BugZap13
  • Locked
  • Question
Need help creating a date from two fields to be used in where clause
Replies
5
Views
500
mikrom
mikrom
TrekBiker
  • Locked
  • Question
Select addresses using two criteria, one 'Like&quot; 2
Replies
3
Views
441
TrekBiker
TrekBiker
Swi
  • Locked
  • Question
Jet Sql Statement - Select Distinct Multiple Columns 1
Replies
4
Views
860
Swi
Swi
TrekBiker
  • Locked
  • Question
Records in one table not in another 1
Replies
3
Views
450
Andrzejek
Andrzejek
datajockey123
  • Locked
  • Question
Note / Information box with date and time stamp for each entery
Replies
2
Views
747
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top