Wildcard yields no records

S

Sarah

I have a table with a field I want to search for using a
wildcard. My query criteria is [Enter Name]. The field
property is Text and there are no masks on it. To get
Lockwood, Lock, Locke etc. I've typed Lock* as the
variable but the query returns no records. What am I doing
wrong?
 
S

sarah

Well that didn't work but I kept trying and searching and
found that this did: Like [Enter Name] & "*" You got me
on the right path- thanks!
-----Original Message-----
Use [Enter Name] & "*"

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
[email protected]
www.pcdatasheet.com


I have a table with a field I want to search for using a
wildcard. My query criteria is [Enter Name]. The field
property is Text and there are no masks on it. To get
Lockwood, Lock, Locke etc. I've typed Lock* as the
variable but the query returns no records. What am I doing
wrong?
Click to expand...


.
Click to expand...
 
Top