MS Query - Going around in circles [SOLVED]

[ianb]

Hi everyone... probs a simple one just over worked !!! after over 50 queries this is the last one.


WHERE (ResolvedOPALISReport.

Owner Name='OPALIS') AND (ResolvedOPALISReport.[code]Summary* <> '%Query') AND (ResolvedOPALISReport.[code]Group*+<> 'Awaiting Authorisation') OR (ResolvedOPALISReport.Owner Name

='OPALIS') AND(ResolvedOPALISReport.Summary*[/code] <> '%Password') AND (ResolvedOPALISReport.Group*+[/code]<> 'Awaiting Authorisation')


Why is this giving me all data with password or query in the summary !!!!!!

I just need to remove the two above and all the data is correct....!!!


All data to show :


1. = OPALIS

2. NOT Awaiting Authorisation


3. NOT containing Password

4. NOT Containing Query


Many Thanks.

 

[ianb]

Thanks Guys.. just when you think its all over.


WHERE (ResolvedOPALISReport.

Owner Name='OPALIS') AND (Not ResolvedOPALISReport.[code]Group*+='Awaiting Authorisation') AND (ResolvedOPALISReport.Summary*

Not Like '%Query%') AND (ResolvedOPALISReport.Summary*[/code] Not Like '%Password%')


Mental Block is now free...