How to make daily stock inventory

[Moore71]

Hi guys,i have an inventory app,i want an idea on how to make daily opening stock /closing stock.I want the system done automatically,that is as users exit,closing stocks & next day opening stocks as users log in.Then daily stock reports can be generated.
Thanks in advance anyway

 

[CJ_London]

Opening/Closing stock is a calculated figure, so should be calculated.

For this figure you will need something like

OpeningStock=DSUM("[StockTrans]","tblStock","TranDate<Date() AND StockID=" & me.stockID)
ClosingStock=DSUM("[StockTrans]","tblStock","TranDate<=Date() AND StockID=" & me.stockID)

 

[Moore71]

Thanks for the response.This is an eye opener to me that nothing is impossible with good thinking
Thanks alot