Exclude within script, except for...

[fanninam]

I need to exclude Account# 5306510 but only for Department# CC235, otherwise I want to include it.

I only know how to exclude account numbers as seen below.

Where T$OYER >=2014 and not WildMatch(T$LEAC, '5706710','5706730','5706750','5706770','5849990','5839991','3100100','4101100','5839990','5306505','5306515','5805985','5829990','5805954','5805950','5255830');

[maxgro · Accepted solution]

where

     not

     ( Account# = 5306510 and Department# = 'CC235')

[sunny_talwar]

or you can do thos:

Where Account# <> 5306510 or Department# <> ''CC235';

[maxgro]

not (X and Y) becomes (not X or not Y)

[sunny_talwar]

Right, did I miss something by mistake or are you just explaining the logic to the OP

[maxgro]

I was explaining to myself. I must admin I forgot the boolean algebra and I had to think a little to remember your answer and mine answer are the same. 

[sunny_talwar]

Yes I replicated your response by twisting it around

[Peter_Cammaert]

I think you should split the rewards

[sunny_talwar]

I think maxgro‌‌ deserves it

[fanninam]

Thank you Massimo!  This worked!