|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
January 27th, 2005, 04:25 PM
|
|||
|
|||
In Access, How can I set criteria to only choose records NOT cont.
In Access, How can I set criteria to only choose records NOT containing a
certain word. I get if I type "dog" in the criteria, it will only show me records containing the word dog....what if I want all records NOT containing the word dog, then what do I type? 
|
|
#2
January 27th, 2005, 05:15 PM
|
|||
|
|||
|
Not Like "*" & "dog" & "*"
-- PC Datasheet Your Resource For Help With Access, Excel And Word Applications www.pcdatasheet.com "schwdm" wrote in message ... In Access, How can I set criteria to only choose records NOT containing a certain word. I get if I type "dog" in the criteria, it will only show me records containing the word dog....what if I want all records NOT containing the word dog, then what do I type?
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| In a multi-user database, how to restrict access to records | Bikerman | Database Design | 5 | April 20th, 2005 05:42 PM |
| MS Access criteria HELP!! | dawnovan71 | Running & Setting Up Queries | 3 | January 27th, 2005 05:29 PM |
| WORD XP mail-merge FAILS using ACCESS Query | SueMackay | Mailmerge | 1 | November 23rd, 2004 01:03 PM |
| Merging MS Word document with MS Access 2002 criteria query | Doug Robbins | Mailmerge | 2 | November 4th, 2004 05:57 PM |
| Access XP Compared to Access 2003 | Mardene Leahu | New Users | 1 | October 1st, 2004 05:11 AM |
Linear Mode
