Find string w/in string via query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I would like to know how to create a query where the field could be: FFF,
LLLL, SSS, or any combination of the above, i.e.:

FFF; LLLL; SSS
LLLL; SSS; FFF
SSS, FFF; LLLL
FFF; LLLL;
FFFF
LLL; SSS

.... you get the idea. In essence, I need to say if the field contains
<search> then match is good.

Thanks.
 
The table is "My Outlook Calendar". The field is Category. I am searching
for the following:
LLLL,
SSS, or
FFF, or combinations of the above. Anything else found should be ingnored.
 
Open the query in the design view. Use this as criteria for the Category
column.
Like "*LLL*" Or Like "*SSS*" Or Like "*FFF*"

In you example of LLLL you three some of the time and four at other times.
I assumed you wanted three L's. It will pull four L's also.
 
Back
Top