the error message im getting is

'Invalid column name'

refering to BOTH THE COLUMNS  where ive used CASE

Think I missed out on that where can I download a beta copy would be nice to see how this could work better for me thanks

an export to Excel defined by a query ....?

Please enlighten me maybe we're calling the same thing a rose?

Thanks guys , hopefully i can adapt that

my original Query Would only look at the top level firm and then the secondary level ,

i haven't yet been able...