Hey guys,

Thanks for the quick reply. I tried the UDL file connection thing but wasn't able to get it to work.

Do i need to change any setting in SQL Server...

Alright, I see where my error was when I adapted the code to fit my needs. It's all fine now and everything is working as it should

I see where we are heading here, and i have tried out the code you gave on the NorthWind database. Now I want to sum COUNT1 and COUNT2, but when...

I get what you are trying to do but unfortunately I am not very good in SQL Server's syntax and I have no idea on how to put a CASE...

Hi there Phil,

I tried out your suggestion and it won't work. Besides that, it won't give me the results I want because the having clause filters whatever is returned...