Hello,

I have Custormers table.

Name : Text
Address : Text
BDate : Date
Notes : Memo

Sometimes, I need to query Memo field.

I have a CForm which has a field named Search.
I want to query all Notes fields in Customers table via CForm!Search field.

Should I make a query like this? I use IN but I doesn't work.

SELECT Customers.Notes, Customers.Name, Customers.BDate
FROM Customers
WHERE (((([Forms!CForm!Search]) In (Customers.Notes)));

Thank you for your help,

Osman

How would you do it if you were looking for a certain letter in a text field in your table?