Sorry for being vague early. Are you familiar with MDX query? I actually need the SQL query formatted to MDX.

John R. you suggested the below:

SELECT *

FROM @Table

WHERE RIGHT(GLnum,2) <>...

Sorry this is all new to me. Awesome! Thanks, I will give it a shot.

John, for your query, I would have to list out all the accounts, correct? Is there a way to avoid that?

Thanks guys, these are great suggestions. However the problem I encounter is that this account is made up of over 50 accounts. I am trying to avoid writting out each...

But what happens when a new account is added, then I have go and tweak the formula, too much work. Is there a way the system can look at only...