Thanks Sarah,

How can I aggregate the distinct values only?

For example said person may appear multiple times per week, but how do I count them only once?

I guess there is no way of resolving this?

Looks like my colleague and I have sorted it 🙂

Thanks for this David,

Much appreciated

I will learn from this so that in future the expressions make more sense 🙂

Thanks for replying, basically if today is a Friday then show the data for Saturday, Sunday, Monday, if it's not a Friday show the data for the following day based...

Thank you for your help guys

It works 🙂

Appreciate it, thank you

Appreciate you helping me here so it would be 28/01/2015 - 24/02/2015

The 24/2/2015 because the last 3 working days of the month are the cut off.

So basically if the first day of the current month was a Sunday, I would want to capture everything from the Wednesday

If the first day of the next month was...

Thanks for the replies guys, unfortunately we don't have access rights to create stored procedures (we as the reporting team are subservient to the IT team/database administrators).

I will also be...