LIKE operator?

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-
 
J

John Mishefske

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

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

Problem with the Like Operator 2
Alike operator replacing Like; I don't know why or how to fix 1
Query criteria - the Like operator 5
Difficulty with LIKE operator 4
Pass Operator to Criteria in Query 2
Multiple Parameters to search a field 1
How to use the Like operator in Parametric queries? 2
Query using Like Operator 2

Top