|
| 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
May 5th, 2009, 01:37 PM
posted to microsoft.public.access.queries
|
|||
|
|||
"Not" Query
Ok, having a case of "vapor lock" here.
I have a query tracking sites on the body, (ie, brain, arm, ear, etc) How can I make a query to track those which are not equal to brain, arm,ear, etc? Thanks -- thomp 
|
|
#2
May 5th, 2009, 01:53 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
"Not" Query
The like() function should do it.
So you would use the criteria in your query to show everything that is not like(). not like(*brain*) or not like(*arm*) or not like(*ear*) Bonnie http://www.dataplus-svc.com ThomP wrote: Ok, having a case of "vapor lock" here. I have a query tracking sites on the body, (ie, brain, arm, ear, etc) How can I make a query to track those which are not equal to brain, arm,ear, etc? Thanks -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...eries/200905/1
|
|
#3
May 5th, 2009, 02:04 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
"Not" Query
Thank you so much, worked.
-- thomp "bhicks11 via AccessMonster.com" wrote: The like() function should do it. So you would use the criteria in your query to show everything that is not like(). not like(*brain*) or not like(*arm*) or not like(*ear*) Bonnie http://www.dataplus-svc.com ThomP wrote: Ok, having a case of "vapor lock" here. I have a query tracking sites on the body, (ie, brain, arm, ear, etc) How can I make a query to track those which are not equal to brain, arm,ear, etc? Thanks -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...eries/200905/1
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
