G
Guest
I have 2 tables:
One is inventory: Part_number, Amount_in_inventory
The other one is reservation of the part number (orders): Part_number,
Start_date, End_date, Quantity.
When people put in reservations I need to update the inventory (to see if I
have enough to fill peoples request). So I have a query that display
Amount_in_inventory - Quantity. So far so good.
I need a table that gives me a date (start_date) and how much do I have in
inventory for that date. I can do that, my problem is, what do I do for the
range between the start_date and the End_date. For example, I have 5 units
of a PartNumber. One is reserved for 1/1/04-1/8/04. I can show that at
1/1/04 I only have 4 in inventory. But how do I tell it to display that
1/2/04 is also 4 in inventory, and 1/3/04 and do on and only at 1/9/04 it
goes back to 5 units.
One is inventory: Part_number, Amount_in_inventory
The other one is reservation of the part number (orders): Part_number,
Start_date, End_date, Quantity.
When people put in reservations I need to update the inventory (to see if I
have enough to fill peoples request). So I have a query that display
Amount_in_inventory - Quantity. So far so good.
I need a table that gives me a date (start_date) and how much do I have in
inventory for that date. I can do that, my problem is, what do I do for the
range between the start_date and the End_date. For example, I have 5 units
of a PartNumber. One is reserved for 1/1/04-1/8/04. I can show that at
1/1/04 I only have 4 in inventory. But how do I tell it to display that
1/2/04 is also 4 in inventory, and 1/3/04 and do on and only at 1/9/04 it
goes back to 5 units.