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...

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...