Solved: Searching text and memo fields

[calenger]

Hi

Does anyone know how to search for keywords in multiple fields in a access 2000 database. We have a keywords field that contains multiple keywords for each record. I need to be able to prsent the user with only the records that contain the keyword they are searching for.

Thanks

[geekgirlau]

You can do this easily in a query in a couple of ways:

Have the criteria in separate rows (Like "*smith*") in each field you want to search.
Create a Filter field in a query that contains all the fields you want to search, and have the single criteria on that field.

SELECT [txt_Cust_FirstName] & "_" & [txt_Cust_Surname] & "_" & _
[txt_Cust_Nickname] AS TestFilter
FROM tbl_Customer
WHERE ((([txt_Cust_FirstName] & "_" & [txt_Cust_Surname] & "_" & _
[txt_Cust_Nickname]) Like "*smith*"));

[calenger]

Thanks