GROUP BY Date Before Count, Multiple Nested

[Delid4ve]

Hi Guys,

After consolidating/rewriting all my sub queries to remove grouping and merge into one on testing I have realised that i need to break it down slightly. Been trying for hours now to get the result I need but now is the time to ask for help. HELP!! Or even shout

The current Result I get is CurrentQueryResult.png.
Which is counting Bankholidays, reserveddays and calloutdays as a total for each contract.

What i need is it to count the total for each year of each contract.

I just cant seem to get this nested correctly.

 

[mikejaytlabustro]

I think you have to include the actual Dates, then add another field that Format(YourDateField,"YYYY"). Group by ContractID and Group by Year