Searching text in memo fields of Access 2003

D

David

Hello,

I would like to know if it is possible to search for specific text within
memo fields of Access 2003 databases?
 
M

Marshall Barton

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*"
 
Top