SQL Auto Increment Date

caulson

Hi, how to use SQL auto increment date that calculation with received item ?

As below is an output example i want.


[u]Date Received OnHandbalance balance Plan Usage [/u]
22/6 12 10 6day 2
23/6 10 8 5day 2
24/6 8 6 4day 2
25/6 6 4 3day 2
26/6 4 2 2day 2
27/6 10 12 10 6day 2