Member Avatar for Sadhikary

date wise stock report needed....

  • 2 Contributors
  • 3 Replies
  • 97 Views
  • 2 Hours Discussion Span
  • Latest Post Latest Post by pritaeas
Member Avatar for pritaeas

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

Member Avatar for Sadhikary

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

Member Avatar for pritaeas

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.