Simple query advise

[Sid3335]

i have the following query:

Select tblSearch.intSuccess From tblSearch Where tblSearch.website = 'TEST' OR tblSearch.website = 'RR TEST' OR tblSearch.website = '' And tblSearch.intSuccess = 0

the problem is that is returns the results and ignores the intSuccess = 0.
it returns the value whatever it is.

Whats wrong with the query? thanks guys

[chazzy]

you need to put parenthesis around the logic you want it to show.

I think you want it like this:

[code]
Select tblSearch.intSuccess From tblSearch Where (tblSearch.website = 'TEST' OR tblSearch.website = 'RR TEST' OR tblSearch.website = '') And tblSearch.intSuccess = 0

[chrisranjana]

Select tblSearch.intSuccess From tblSearch Where (tblSearch.website = 'TEST' OR tblSearch.website = 'RR TEST' OR tblSearch.website = '') And tblSearch.intSuccess = 0

Might solve the problem

[chrisranjana]

Wow Chazzy beat me to it by 1 min !

[Sid3335]

thanks guys, worked a treat