• Hi

    Thanks for this solution which works fine.

    Having said that, it only works if the Data Range is specified in the SELECT part of the query.

    If I put the Range in the WHERE Clause, it still aggregates/sum from all the previous dates.

    Thanks for spending the time helping me!

    I'll carry on digging and will put a solution ... if/when I find one.

    Cheers