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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

last recordset 4
Use In() Expression as Query criteria with guts from Function 1
Help needed in Criteria Field Please. 3
access 2007 criteria in query 2
Multiple Parameter Crosstab query filter by form 1
Parameters to search between years 2
Access Dcount (multiple criteria) 3
NOT LIKE search criteria 13

Back
Top