query

  • Thread starter Thread starter Pass-the-reality
  • Start date Start date
P

Pass-the-reality

In my query, my field name is "Associate". For my criteria I have
[LastName]. When the query runs, I can insert a last name (Smith) into the
pop up and only those records will show. However, how do I change my
criteria to say Like"*[LastName]*" so that if the last name
stored in the table is Smithx, if I type Smith in the pop up it will show
that record.
 
Like "*" & [LastName] & "*"


The above criteria will return any name that contains the string
entered. so if smith is entered, smithx will return but so will
blacksmith



If you want to only catch smith* (and not *smith) you could try: Like
[LastName] & "*" but you would have to test it.
 
Back
Top