1.11M Members

Sumation

 
0
 

date wise stock report needed....

 
0
 

Very vague. Give more details of what you have and what you need help with.

 
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

Attachments
 
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.

You
This article has been dead for over six months: Start a new discussion instead
Post:
Start New Discussion
Tags Related to this Article