# how to calculate the quantity of each item sold?

• ### Question

• how to calculate the quantity of each item sold?
Saturday, April 16, 2011 4:47 AM

• That is still not enough information.  Is the sales information being accumulated in a database?  If so, then you need to create a query that is based on the sales records selected for a specific date and accumulated for each stock item. If you need assistance doing that then the you need to idicate what database is being used and what tables and fields are available for the calculation.   If the data is not being accumulatd in a data base then you need to describe just how it is being maintained.

• Proposed as answer by Tuesday, April 19, 2011 2:43 AM
• Marked as answer by Wednesday, April 27, 2011 9:54 AM
Sunday, April 17, 2011 6:24 AM

### All replies

• Dim Sold = CurrentStock - PreviousStock
Success
Cor
Saturday, April 16, 2011 6:01 AM
• Get it from the user?

Pluck it out of thin air?

One of these might to helpful but without knowing more that's a guess. :-)

Regards David R
---------------------------------------------------------------
Every program eventually becomes rococo, and then rubble. - Alan Perlis
The only valid measurement of code quality: WTFs/minute.
Saturday, April 16, 2011 9:19 AM
Saturday, April 16, 2011 4:26 PM
• how to summarise the quantity sold for each item based on user's selection at the end of daily sales

• Merged by Tuesday, April 19, 2011 9:48 AM double post
Sunday, April 17, 2011 4:53 AM
• it was based on user's selection and calculate how many were sold for each item by the end of each day

Sunday, April 17, 2011 5:00 AM
• You need to give more details of what you are trying to do. We are no mind readers.
Only performance counts!
Sunday, April 17, 2011 6:10 AM
• That is still not enough information.  Is the sales information being accumulated in a database?  If so, then you need to create a query that is based on the sales records selected for a specific date and accumulated for each stock item. If you need assistance doing that then the you need to idicate what database is being used and what tables and fields are available for the calculation.   If the data is not being accumulatd in a data base then you need to describe just how it is being maintained.

• Proposed as answer by Tuesday, April 19, 2011 2:43 AM
• Marked as answer by Wednesday, April 27, 2011 9:54 AM
Sunday, April 17, 2011 6:24 AM

Sunday, April 17, 2011 6:27 AM
• Hi W4e,

Thanks for posting in the MSDN Forum.

Any update? I have marked Acamar's reply as answer, if you think it provides no help, please unmark it, and  feel free to let me know your any concerns.

Thank you for your understanding and support.

Best Regards,
Mike Feng [MSFT]
MSDN Community Support | Feedback to us
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Wednesday, April 27, 2011 9:54 AM