date wise stock report needed....
Sadhikary 0 Newbie Poster
Recommended Answers
Jump to PostVery vague. Give more details of what you have and what you need help with.
All 3 Replies
pritaeas 2,211 ¯\_(ツ)_/¯ Moderator Featured Poster
Very vague. Give more details of what you have and what you need help with.
Sadhikary 0 Newbie Poster
I have 2 tables one is receive and another is sale table.
Receive Table contains
Receive
Sale Table contains
Sale
Now how i can see the stock report after calulating above 2 tables, stock report format like below:
Stock
Date wise Stock report needed.
code in vb.net and database is in ms access.
Waiting for someone's valuable reply..
Saurav
pritaeas 2,211 ¯\_(ツ)_/¯ Moderator Featured Poster
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.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.