http://www.kitcle.com/files/move.gif

i have been trying to create a query that will give me a running total for movement ( beginning, In ,Out, and Adjust ) quantities.

function RunningSum it's work but i want to show look like this



thank you

just have a totals query with those columns

assuming you have a movements table then in/out/adjust are all sums from the movement table, and the others come from the stock items table, with the exception of the net balance, which is a calculated figure

ok
but to see field "beginning inventory" it's fill Auto <--------------- next record it quote from field "ending inventory" current record

A : "why dont we do in excel , it 's so easy cal "
B : " because i am access . "

how to do that ? help me

i see what you mean

dont try and do this in the query - you can do it on the report when you print it (there is a running sum option) , and you can probably do it on a form as well if you like (although it will be a bit more work)