Thanks Steve, That is a great reply. I haven't tried out ChatGPT. Really appreciate your help.

Thanks guys really appreciate your input and great solutions.

Hi @Jeffrey Williams,

Wow, thank you for taking the time to put that together. I have tried it on my machine and it looks good. The production server this will run...

Sorry Jeff, you are right my sample data was not correct, I must have copied the wrong thing at the time.

The results are right below as lease ref 5 would...

Thanks SCDecade, I tried your script but it won't work in SQL 2008, I should have mentioned the version I am using. I will see If I can find a...

Hi Jeff, thanks for your reply. The dates will not changes each year they will remain the same. What are your thoughts based on this? Thanks.

To be honest, Calendar...

Thank you guys. That's very helpful. I will take a look at this documentation.

Thank you for the reply Thorn. The example below are the results I would like to see.

typeitem_feedbf_Fee     pcc_feebooking_total_fee
a4.00     ...

Thank you very much Luis, two great answers. I can see how they are working so will know where I am at next time. Thanks again.

Sorry, correction! I had left a reference to the year in the query. I think this is now resolved! Many thanks. I will come back if I hit another issue.

Yea the year column isn't needed there. I have removed it and I still get duplication on the days in January.

I just need a true reflection (count) of those adults...