Filter on Memo Field Contains Searchstring (Access 97(SR-1))

Topic

New Reply

I need to ristrict a recordset to records that contain a user specified search string somewhere in a memo field.

Any ideas how to do it !

Reply | Quote

Replies

If you use a parameter query the SQL would look like this:

SELECT TBLNAME.COMMENTS
FROM TBLNAME
WHERE (((TBLNAME.COMMENTS) Like "*" & [ENTER SEARCH STRING:] & "*"));

HTH

Reply | Quote

Thanks Mark – I was being thick this morning (nothing new there then !)

I will take the rest of the week off.

Cheers!

Reply | Quote