Dear All,
while applying the following criteria in query design view field [TenantName] gives all the records matching of three character anywhere in the string.
Note : But i want it match only first three character and then return the only matching three character result.
ex: Lacoste , lacruty , adhoclacry
if i type lac it will only return all the string which match first three character lac.
result expected :Lacoste , lacruty not adhoclacry
Like "*" & Left([Forms]![WPQueryF]![TenantName],3) & "*"