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...