Recent content by John_Luke

Many thanks for your help I will try the query above. Indeed the total records in my consolidated table is 255K and growing. I usually use excel for everything but this time I need a dynamic sheet/table per customer that updates every time my consolidated table grows. I have ordered the table...

Hi, I am trying to create a running total using DSUM in an example list below: But it is causing my machine to lag so Im wondering if my code is wrong Customer Date DC Balance Client 1 14/01/19 10 10 Client 1 14/01/19 15 25 Client 1...