Search results

Ah I see, yes my table has a date field, i only left it out to make it easier to represent the table on here. I have three fields named as follows located in "Table1": Item, Date, and Qty. Should I add a fourth field with something like this? Balance:dsum("qty", "Table1" ,"item = [item]")

Hi all, I am new to using access and trying to work out a query that will transform the set of data I have into one with a sort of running total figure. The data I have is in the format shown here: Left hand field is item, right hand field is movement of that item a 1 a 5 a -1 b 2 b -3 b 2...