2
Contributors
3
Replies
4
Views
4 Years
Discussion Span
Last Post by pritaeas
0

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

0

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.
Be sure to adhere to our posting rules.