Like Expression criteria

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

Guest

Hello,

I am trying to set up a parameter query to search by
company name.I would like the search to use the first four
or five letters of the name.I have forgotten the criteria
for the "LIKE" expression.......can you direct me please?
Thanks
 
Good morning

The expression you are looking for is:

Like "*" & [txtMyText] & "*"

Hope this helps

Maurice St-Cyr
Micro Systems Consultants, Inc.
 
Back
Top