How to sum up all shipped orders for a specified time frame
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.