Formating in criteria

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

Guest

Hello all,

I am trying to use the "like" statement with a variable in the criteria of a
query.

I am using something like this, but not working.

This works, but I want it dynamic

like "*AED1245*"

I want something like this, but don't know the format

like [forms]![fmList]![txLkup]

How do I add the *before&after*
 
Add them in as separate items using the & character to combine them with the
value in txLKup

LIKE "*" & [forms]![fmList]![txLkup] & "*"
 
You must log in or register to reply here.

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

VBA: How can I use a string variable as autofilter criteria? 4
Use In() Expression as Query criteria with guts from Function 1
access 2007 criteria in query 2
using a date variable in query criteria 3
How To Specify No Criteria 2
More than one criteria value in a query 1
dsum with multiple criteria and decimals 0
Access Dcount (multiple criteria) 3

Back
Top