View Full Version : Find a word in a Memo Field Query


fenhow
07-31-2007, 06:43 AM
Hello,

I asking to see if it is possible to run a query on a memo field. For an example I want to pull all records where the memo field contains the word "Test".

Is this possible?

Thanks!

Fen

Ron_dK
07-31-2007, 07:01 AM
I would suggest to make a query with something like :

SELECT [Yourtable].yourmemofield
FROM [Yourtable]
WHERE ((([Yourtable].yourmemofield) Like "*Test*"));


Hth