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] & "*"
 
Back
Top