F fenhow Registered User. Local time Today, 06:49 Joined Jul 21, 2004 Messages 599 Jul 31, 2007 #1 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
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 Cool bop aficionado Local time Today, 15:49 Joined Sep 5, 2002 Messages 2,141 Jul 31, 2007 #2 I would suggest to make a query with something like : SELECT [Yourtable].yourmemofield FROM [Yourtable] WHERE ((([Yourtable].yourmemofield) Like "*Test*")); Hth
I would suggest to make a query with something like : SELECT [Yourtable].yourmemofield FROM [Yourtable] WHERE ((([Yourtable].yourmemofield) Like "*Test*")); Hth