spacepro
Registered User.
- Local time
- Today, 06:20
- Joined
- Jan 13, 2003
- Messages
- 715
Hi,
I have a warehouse management database.
My tables include orders,store orders,returns, goods inwards.
I have created reports for each of these, but I want a report that will take a opening stock figure from my inventory table then add the goods inwards to this figure, then subtract the orders,store orders and add the retuns to come to a figure which will be the closing stock figure.
I will want to report by date. i.e. via query, but I don't know how to extract the totals of each product or can I take the grand totals from each of the in dividual reports to make one report.
Any help will be much appreciated.
Many Thanks
I have a warehouse management database.
My tables include orders,store orders,returns, goods inwards.
I have created reports for each of these, but I want a report that will take a opening stock figure from my inventory table then add the goods inwards to this figure, then subtract the orders,store orders and add the retuns to come to a figure which will be the closing stock figure.
I will want to report by date. i.e. via query, but I don't know how to extract the totals of each product or can I take the grand totals from each of the in dividual reports to make one report.
Any help will be much appreciated.
Many Thanks
