Hey
I have the following query to search 3 fields Category,title,details
I do not know hot to use and or together.
The search form has a box for details and a listbox for category
I want that when it searches the db it the category be exactly like what the user chooses from the list BUT it searches both the title or description for details the user enters.
this query works but if for ex the category is the same but the title or details does not exist it will produce no result
I think the problem is with these 2 and or
if I use both operators with "and" then all the input should be right

Rs.Open "SELECT * FROM products where Category like " & "'%" & strKeyword & "%'" &_
    " and title like " & "'%" & strKeyword & "%'" &_
    " or details like " & "'%" & strKeyword & "%'" &_
    " order by " & strOrder & " " & strSort, Conn,3, 3

It is unclear to me the exact result you desire.

My best guess is as follows:
Select records where the category is a match, and either the title OR the details match. (By match, in the context of your select statement, I mean "Like"... since you are using "Like", which means that a match occurs when the field contains the value between the percent signs anywhere within it).

If this is your quest, then you must parenthesize thusly:
Select records where the catergory is a match and (either the title or the details match)

So changing your code will produce this result (assuming there are no typos, etc):

"SELECT * FROM products where Category like " & "'%" & strKeyword & "%'" &_
    " and (title like " & "'%" & strKeyword & "%'" &_
    " or details like " & "'%" & strKeyword & "%')" &_
    " order by " & strOrder & " " & strSort

I hope that helps. Please let me know if I misunderstood your question




Woody Z http://www.learntoprogramnow.com

That is exactly what I mean.Sorry for confusion because english is not my lang.
thanks a lot woodyz

Ahh... don't worry about the confusion - it is usually my fault when I don't understand something.

You're welcome - I hope that solved your problem...

Woody Z http://www.learntoprogramnow.com