Recent content by PaulSW

Thanks for this arnelgp but it is a cumulative total rather than a rolling/moving 12 month total. I have already already catered for this in my customerinvoice query.

Hi Tom Thanks for this suggestion. I had to make some slight tweaks as detailed below: SELECT Sum(SumOfTotalCost) AS RollingTotal, RYear, RMonth FROM sqInvoiceMonthTotal WHERE (((DateSerial([RYear],[RMonth],1)) Between DateAdd("yyyy",-1,[RMonth]) And "DateSerial")) GROUP BY RYear, RMonth...

Hi I'm creating a simple Customer Invoice db for a friend. I've created the customer & invoice tables, and a query "CustomerInvoice" that details each invoice per customer where recorded. I've also created an aggregate query (based on the "CustomerInvoice" query) that sums the total amount of...