Hi i'm pretty new to Access and would really like some help.
I have a stock table with stock in and out records :
SKU stock_in stock_out date
wab001 10 10/11/2017
wab001 5 11/11/2017
tab002 6 11/11/2017
tab002 5 12/11/2017
wab001 4 12/11/2017
tab002 3 13/11/2017
I would like to query this and produce the following and also call the query with a report
SKU Stock_in Stock_out current_stock
wab001 15 4 11
tab002 11 3 8
Can anyone help ?
Thanks Kev