"Not" Query

[ThomP]

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

 

[bhicks11 via AccessMonster.com]

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]

Thank you so much, worked.
--
thomp

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