Start New Discussion within our Software Development Community

I have 2 tables one is receive and another is sale table.
Receive Table contains
Receive

Receive1
Sale Table contains
Sale1
Sale

Now how i can see the stock report after calulating above 2 tables, stock report format like below:

Stock
Stock1

Date wise Stock report needed.
code in vb.net and database is in ms access.

Waiting for someone's valuable reply..

Saurav

Join both tables on InvoiceDate and ModelCode. Then you can use GROUP BY and SUM(). Opening stock may be a little harder to get, as it's based on all previous records.

This article has been dead for over six months. Start a new discussion instead.