Searching text in memo fields of Access 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I would like to know if it is possible to search for specific text within
memo fields of Access 2003 databases?
 
David said:
I would like to know if it is possible to search for specific text within
memo fields of Access 2003 databases?
Click to expand...


Yes. Use the Like operator along with wildcards, something
like:

SELECT *
FROM thetable
WHERE memofield Like "*specific text*"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Memo fields not displaying in query 4
Access displaying HTML 3
Make Table Query Truncating Memo Field at 255 Characters 2
how can I specify text criteria when querying a memo field 1
Memo fields in a query 4
Search for a word in a memo field ? 3
disctinct query memo field 3
Query with memo field shows only two chinese charcters when linked 3

Back
Top