Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Access Training and help » Searching contents of text/memo fields
|
|
|
Bookmark this page|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Searching contents of text/memo fields
Resolved · Low Priority · Version 2003
Reply
Searching contents of text/memo fields
HiIs there a way to search the contents of a memo or text field other than using wildcards, which will bring up all the records that has that word in the related field.
For example the filter function in excel has the 'contains' or 'does not contain'
Many Thanks
For upcoming training course dates see: Pricing & availability
RE: Searching contents of text/memo fields
Hi Camilla, thanks for your query. You can do this, although I'm a bit worried about your desire to not use wildcards. Is there a reason for this?In the design view of a query use the criteria write:
Like "*internet*"
This will pull out those records where that particular field contains the word internet. You can also use "Not Like" to exclude those answers and then cascade the queries down through "Or" text boxes to run the query on multiple fields. You need the asterisk wildcards in the query, however, so the query searches within whatever text is in that field.
Hope this helps,
Anthony
|
 |
|
» Forum post: Sound |
Can I add imported sounds onto transitions etc.
