Hey there, I have the following code that works just fine, but I would like for it to filter/search through another category.

"SELECT SupplierName, Location, ShortDescription, TimberSpecies, CategoryTitle, Country
FROM Query1
WHERE TimberSpecies LIKE '%" + Replace(rsSearchResult__MMColParam, "'", "''" + "%' AND CategoryTitle LIKE '%" + Replace(rsSearchResult__MMColParam2, "'", "''" + "%' AND Location LIKE '%" + Replace(rsSearchResult__MMColParam3, "'", "''" + "%'
ORDER BY SupplierName"

In this code I would like for the search to also search all customers with the "Retail-Trade" category. "Wholesale" I want to exclude.

Table Name: Query1
Column Name: BusinessType
Record or Category Names: Retail-Trade & Wholesale.

Is this possible with the code I have supplied?

Thanks again.

Mally.