|
Within queries
LIKE [Parameter] & "*"
or
LIKE "*" & [Parameter] & "*"
From code:
strTmp = Forms!FormName!Control
strSQL="SELECT * from Employees WHERE LastName Like
'*" & strTmp & "*'"
or
strSQL = "SELECT * from Employees WHERE LastName Like '"
& strTmp & "*'"
|
