I'm gobsmacked ! Never knew you could do that also 🙂 Ahh the joys of learning 🙂

Thank you very much once again, all works tickety boo 🙂

Wow, you can do that ? I never knew.

That really works 🙂 but I had to take out , (NumberRenewed * 100.0) / RenewalsDue As PercentRenewed, as i get a...

hmm, looks great and i sort of get the idea but unfortuantely it doesn't compile in sql and returns an incorrect syntax near keyword ON. I think it has soimething...

I don't think it's as straight forward as that. Here is the query, I need to add another column showing the Renewal percentage of NumberRenewed against RenewalsDue.

SELECT     res.AccountNumber, cust.AccountName, orders.WebID,...