AnsweredAssumed Answered

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

Question asked by PatrickHolzer on Feb 9, 2009
Latest reply on Feb 19, 2009 by 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

Outcomes