PDA

View Full Version : Help with code to filter through database.


malhyp
05-06-2006, 11:19 AM
Hey there, the following code works perfectly, but I would like to add one more bit to it.

"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"

I would like to add; WHERE BUSINESS TYPE = RETAIL-TRADE.

I don't know how to combine this with the current code.

Thanks again.

Mally.