Problem with And/Or Condition in Query

[beachcomber]

Hi,

I'm having a problem with my query below. Basically,
I have 3 user entered parameters that I'm trying to work
into the query. The second and third parameters are an or condition. For some reason, this query keeps returning all records in the system. Does anyone see anything I'm doing wrong?

"Select * From Customers where Customers.LastName Like " & "'%" & txtLastName & "%'" & "and Customers.FirstName like " & "'%" & txtFirstName & "%'" & "or Customers.Address1 like " & "'%" & txtAddress1 & "%'"

Thanks,
Beachcomber

 

[cmmrfrds]

You need to enclose the 2nd two parameters in pharens, otherwise the OR gets evaluated separately and is not tied to the second parm.

"Select * From Customers where Customers.LastName Like " & "'%" & txtLastName & "%'" & "and (Customers.FirstName like " & "'%" & txtFirstName & "%'" & "or Customers.Address1 like " & "'%" & txtAddress1 & "%')"

 

[beachcomber]

I had tried parens earlier but not as you had them
Your way was correct.

Thanks very much,
Beachcomber