Statistics in Access 2007

[rodvaN]

Hello again.
I got some doubts about how to create Statistics..
I got a warehouse database, so I wanted to count how many different kind of products I got there.
I have a table for each product with the data from each product, then I nested it into a table with all the joining from all the tables, where Im able to choose different kind of products i got on products table.
What I want to do is to count How many Chocolate bars boxes I got in stock, and the same with all the different products.
How can I do that?
Thanks in advance!

 

[gemma-the-husky]

I think you ought ot redesign your dbns

you really should start with NOT having a different table for each product.

you should have one table for your products, including a productid
another table for product movements (ie receipts and sales), which links to each product via the productid

then it is simple to generate such statistics.

 

[rodvaN]

I didnt explained myself so well I have a column for different products, in the same table.