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