Rows/Columns

[dave1234]

Is there any way in a querie that I can have the data from one product displayed across the screen so that I can do a Sum off that one particular product.
Just think it would be a way of solving the problem I have with doing Stock Takes and updating stock numbers of produce coming in.

Im only doing this in access not visual basic.

 

[Pat Hartman]

Dave,
You started off on a bad foot yesterday by posting the same question 5 times. Today's post is slightly different but I'm still not sure what your problem is. Managing inventory is much more difficult than most people realize. There are numerous posts here regarding inventory management. Just look for the word inventory in the thread topic. Here's one for example:

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=46707&highlight=inventory

Is there any way in a querie that I can have the data from one product displayed across the screen so that I can do a Sum off that one particular product.

- you can achieve that effect with a crosstab query but crosstab queries are not updatable so you couldn't easily use it to update your quantities.

As most of the suggested solutions will tell you, you don't need to store totals. You can just sum transactions up to some point in time to calculate inventory levels.

 

[crook]

What fields do you want in your query?

For example:
1. Product ID
2. Product Name
3. Individual Price
4. Quantity

etc...

Can it sumarize the data for all products in the same query, or do you just want it to display the summary data for one product at a time?