Search results

Hello arnelgp, Fantastic, this works perfectly. You are correct, the data was added from an excel append to table. I am not going to understand your function for a while, but it gives me something to start with. Many thanks.

Hello arnelgp, Many thanks - it's close, but it seems to be missing the running sum when more than one line has the same date. I think i have read about this needing a unique identifier. The actual running sum based on ItemCode is working. I have attached the screenshot. Thanks

Hello arnelgp, Thank you for your reply. I changed the "PartCode" to "ItemCode", my error in above expanation. However i get strange results. First line has a quantity of 1000 and a running total of 122918, second line -200, running total of 208970.... The ItemCode is sorted in order and so is...

Hello, I am very new to access, i wanted to create a project and got stuck creating a running sum over a group in a query. What i have is a table called "tblDemand", the table consists of ID (autonumber), ItemCode, Description, Quantity, Due. I have then created a query from the table, and sort...