How do I create a query which will search through a group of patients notes to find any words I choose?<br>I tried saying, <br>Like [Forms]![listPatients]![Notes]<br>This works, but now I want the query to find the word if it is similar (using a wildcard?)<br>I want it to be able to identify for example "smith", "aassmithssaa", "john smith", is this possible from another form?<br>I hope that isn't too ambigious<br>Thanks<br><br>Ally
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Like Query From a Form 2
- Thread starter ally
- Start date
-
2
- #2
thats very common question<br><br>heres the answer:<br><br>Like "*"&[Forms]![listPatients]![Notes]&"*"<br><br>-the <b>&'s</b> makes the query think you typed <b>*</b>yourquerytext<b>*</b> into the field on the form.<br> <p>Peter Heaton<br><a href=mailto:heaton@characterlink.net>heaton@characterlink.net</a><br><a href= it how ever you want</a><br>
- Status
Similar threads
- Locked
- Question
- Locked
- Question