Sumation

date wise stock report needed....

Contributors

Replies

2 Hours

Discussion Span

4 Months Ago

Last Updated

Views

Sadhikary

Newbie Poster

6 posts since Dec 2012

Reputation Points: 0

Solved Threads: 0

Skill Endorsements: 0

4 Months Ago

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

pritaeas

Posting Prodigy

Moderator

9,309 posts since Jul 2006

Reputation Points: 1,178

Solved Threads: 1,465

Skill Endorsements: 86

4 Months Ago

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

Sadhikary

Newbie Poster

6 posts since Dec 2012

Reputation Points: 0

Solved Threads: 0

Skill Endorsements: 0

4 Months Ago

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.

pritaeas

Posting Prodigy

Moderator

9,309 posts since Jul 2006

Reputation Points: 1,178

Solved Threads: 1,465

Skill Endorsements: 86

This article has been dead for over three months: Start a new discussion instead

You