Search results

I wan't access to calculate partial sums based on dates(formatted american style here), in particular, the amount ordered of a certain product until a certain date instead of the amount ordered at a certain date. So: product date amount a 01-01-2005 1 b...

What I am simulating is the order fullfillment under a (S-1,S) ordering policy. In this ordering policy, the total of outstanding orders + inventory on hand is always S. Say S is 10. Then when someone orders 4, then 4 is ordered from the external supplier and 4 is delivered to the customer. The...

The leadtime is a fifth column, I did not point that out clearly in the first question. It only depends on the product id. (product_nr)

Thank you for all the ideas on how to perform the query. I should have added to the previous question that I am not an experienced access(or sql) user, I only learned access last weak. The group by is just what I get when using the design view of access to make the query. I don't know how to...

I have a query in ms access. (It is used to simulate inventories under (s,q) policies(not really important)). It is used on a big table(1.000.000 entries), with data on ship dates and quantities of about 70.000 parts. It adds to the 4 columns one extra columns, with the usage in the leadtime...