Thanks for that. I can use that in my SQL script to get the result and display from their. Saves messing about in Reporting Services.

Thank you! It was so simple in the end.

Managed to sort it. I missed out Set Datefirst 1 at the top my query after all that!

BOOM! Thanks Sean Lange. Sorted.

Nils Gustav Stråbø (6/12/2012)

---

I don't have access to a SQL Server right now, so I'm not able to test if this will work, or if it performs very well, but...

That script is working great but just have a couple of questions.

If a recorded is removed and then added again against a specific person within the same month, for...

That looks like the kind of thing I'm looking for, many thanks!