LIKE operator?

  • Thread starter Thread starter _Adrian
  • Start date Start date
A

_Adrian

I need to build a query that will allow me to use a LIKE operator.. but I
*also* need to be able to prompt the user for a variable.. obviously, LIKE
[Enter Last Name] doesn't work in the criteria field.. what would be proper
structure to make this work? Thanks-
 
_Adrian said:
I need to build a query that will allow me to use a LIKE operator.. but I
*also* need to be able to prompt the user for a variable.. obviously, LIKE
[Enter Last Name] doesn't work in the criteria field.. what would be proper
structure to make this work? Thanks-
Click to expand...

LIKE [Enter Last Name] & "*"

or perhaps

LIKE "*" & [Enter Last Name] & "*"
 
Back
Top