Find a word in a Memo Field Query

fenhow

Registered User.
Local time
Today, 06:49
Joined
Jul 21, 2004
Messages
599
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
 
I would suggest to make a query with something like :

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


Hth
 

Users who are viewing this thread

Back
Top Bottom