Prev: Displaying data across columns
Next: how to remove html tags from a field in MSACCESS.
From: SQLGal via AccessMonster.com on 23 Apr 2010 18:45
((not like "item 1") and (not like "item 2"))




Iram wrote:
>Hello,
>
>I need help writing a query that will exclude certain data.
>I can successfully exlcude one item but when it comes to excluding multiple
>I can't get the query to work properly.
>If I wanted to exclude Item1 and Item2 from the query what is the proper way
>to write it? The field name is Items and I have multiple items starting with
>Item1 through Item150 but I only want to exlcude Item1 and Item2 from this
>specific query.
>I have written stuff like the following and they don't work...
>Not like "Item1" and "Item2"
>Not like "Item1" Or "Item2"
>Not like "Item1"
>Or
>Not Like "Item2"
>
>Thanks.
>Iram/mcp

--
Message posted via http://www.accessmonster.com

First  |  Prev  | 
Pages: 1 2 3
Prev: Displaying data across columns
Next: how to remove html tags from a field in MSACCESS.