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