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.

 

[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?