2 Replies Latest reply on Feb 19, 2009 9:01 AM by PatrickHolzer

    How to sum up all shipped orders for a specified time frame

    PatrickHolzer

      Title

      How to sum up all shipped orders for a specified time frame

      Post

      Hi,

       

      I have a table called "Orders" and a table called "Products"; the two are related because every order contains a product (and contains only one product) in different quantities, though.

       

      Now,  I'd like to be able to do this:

       

      Set a start-date and end-date (for example 1st of January and/until 15th of January) and then see how many pieces I've sold within that time frame for each product.

       

      Only orders with the status "shipped" should be summarized (orders can be "pending", "cancelled", etc.); every order has a status which is defined via a drop-down list.

       

      Thanks!

      - Patrick