Thread: Wildcards
View Single Post
  #3  
Old December 8th, 2009, 06:27 PM posted to microsoft.public.access.queries
KARL DEWEY
external usenet poster
 
Posts: 10,767
Default Wildcards

Try this --
Like "*denied*access*"

--
Build a little, test a little.


"Emma Hope" wrote:

Hi all,

I have a query where i want to pick all the records with 'denied access' in
them, the records could be as follows;

denied access
denied me access
customer denied access
denied access by customer
customer denied access to me

when i use

like "*denied*" and like *access*" it only returns the last record.....

Do i really have to do:

like "denied*" and like "*access*"
like "denied*" and like "*access"
like "*denied*" and like "*access"

etc etc etc?

There must be an easier way?