date wise stock report needed....
Very vague. Give more details of what you have and what you need help with.
I have 2 tables one is receive and another is sale table.
Receive Table contains
Sale Table contains
Now how i can see the stock report after calulating above 2 tables, stock report format like below:
Date wise Stock report needed.
code in vb.net and database is in ms access.
Waiting for someone's valuable reply..
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.