Help with vb.net stock system

[Mickstar]

Hi Guys,

Im trying to build a stock system for a small cd store, iv got the basics out the way, but i need help with something a bit more complex.

The form i need to build will need to show the weekly sales for each product. The way id imagine i would build was to have a data table with the products down the side of the table and the dates ( 11/03/08 - 12/03/08 - 13/03/08 etc.) at the top. The information in the table will hold the quantity sold for that day. Everytime a sale is processed the qty will be updated on this table.

Does anybody have any idea how i could go about bulding this?

I appreciate any help i get.

Thanks

[stanav]

Well, in oder to sumarize what has been sold, every time you sell something, you have to log the transaction. So you would need a table to hold sale data. The table would contain these following fields at the minimum: item id, quantity sold, date sold. Now when you sell something, just write records to this table.

[Mickstar]

Thanks for the reply. I understand what your saying. Then just store the information in a database. But then its just a big clump of data.

How would i pick out the monthly sales for one item? i need to know this in order to work out how much stock i need to keep on hand and how much stock i need to order in.

[stanav]

Do you know how to query your database? If not, then I strongly suggest you to start learning some SQL and ADO.Net... There are tons of tutorials on the internet.