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.

WHERE TimberSpecies LIKE '%" + Replace(rsSearchResult__MMColParam, "'", "''") + "%' AND CategoryTitle LIKE '%" + Replace(rsSearchResult__MMColParam2, "'", "''") + "%' AND Location LIKE '%" + Replace(rsSearchResult__MMColParam3, "'", "''") + "%' And BusinessType = 'Retail-Trade'

That should do it.

Thanks Adam, it worked perfectly.

TA

Mally.

No problem.

You can add as many conditions as you want to an SQL query after the first one by using the "And (condition)" syntax.