We need the DDL for the table(s), create statements. The tables are already there I did not create them. I am simply querying the data. I have...

Is this what you are looking for?

MyTable

CustomerNumber INT

PolicyNumber INT

StartDate DATETIME

Premium ...

I have been checking the query and I have resluts that do not tally.

My current query sums a series of conditions and it totals the same conditions.

I have tried to...

Thank you Jeffrey. I now have what was fourteen queries into one and no editing of the query required before use. Brilliant.

Thank you this is great.

Thank you Jeffrey. I have used your solution in a number of my queries. How can I change the folowing codes to relate to the current month? Is...

Thank you Mark. I have added your solution to my query. How can count the number of products at the same time?

Select sum (case when (CPP.Service like...

Thank you so much. That will make such a difference.

Thank you.

I'll get back with a more detailed example.

Thank you.

I'll get back with a more detailed example.