previous closing value carry to current opening value

I have 2 tables like following

Stock in Table

Date................ItemName......open.......in......out.....balance
1-2-2018.......A.......................0...........5........0...........5
2-2-2018.......A.......................0...........10......0..........10

Stock out Table

Date................ItemName......open.......in......out.....balance
1-2-2018.......A.......................0...........0........1...........1
2-2-2018.......A.......................0...........0........2...........2

As you can see .. all tables are same schema …and
I can query Stock Ledger with union function for summarize results.

Stock Ledger

Date................ItemName......open.......in......out.....balance
1-2-2018.......A.......................0...........5........1...........4
2-2-2018.......A......................(?)...........10......2...........8

The question is …. I want on (?) Place with 1-2-2018 balance value.

All topic