locked
how to calculate the quantity of each item sold? RRS feed

  • Question

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

Answers

  • 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 Mike Feng Tuesday, April 19, 2011 2:43 AM
    • Marked as answer by Mike Feng 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?

    Add up the individual sales?

    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
  • I think you need to provide considerably more info in order to get any answer that is relevent to your situation.
    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 Liliane Teng 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 Mike Feng Tuesday, April 19, 2011 2:43 AM
    • Marked as answer by Mike Feng Wednesday, April 27, 2011 9:54 AM
    Sunday, April 17, 2011 6:24 AM
  • You have already asked this question here:

    http://social.msdn.microsoft.com/Forums/en/vbgeneral/thread/f39ca232-fa3a-40f1-82ab-5b15ba3b8636

    Please reply to the responses you received there instead of starting another thread.

    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