SQL brings back wrong data

[rlusk49]

With the following sql, I am trying to return data based on 2 criteria, argDirectParent and argSpouseParent. But it is not working. It brings back faulty data based on only one of the criteria. I figured the "And" would do it.

Select * From tblPersons Where Mother = " & Chr(39) & argDirectParent & Chr(39) Or Father = " & Chr(39) & argDirectParent & Chr(39) And Mother = " & Chr(39) & argSpouseParent & Chr(39) Or Father = " & Chr(39) & argSpouseParent & Chr(39)

 

[SonOfEmidec1100]

Try adding brackets as below

Select * From tblPersons Where (Mother = " & Chr(39) & argDirectParent & Chr(39) Or Father = " & Chr(39) & argDirectParent & Chr(39)) And (Mother = " & Chr(39) & argSpouseParent & Chr(39) Or Father = " & Chr(39) & argSpouseParent & Chr(39))

cjw

 

[Transcend]

Hi there

SonOfEmidec1100 is right, without the brackets your statement is broken up so that if one of the OR statements is correct you'll return values that aren't what you want.

Transcend