J
jversiz via AccessMonster.com
Hello,
I've read other posts, but can't quite get my query to do show what I want.
Perhaps I'm still trying to get my brain around the idea.
I have a query that shows the projected sales quantity of a given item, given
month, given week, that week's start date, that week's end date, and given
warehouse. The field name that shows the quantity is called "DistQty". I
also have a query that shows the current on hand quantity for the item and
the warehouse. This field is called "QtyOnHand". I can easily subtract the
two to get a suggested production for my current week, but I need to project
the production for 12 weeks out..Here is where I get lost.
The projected production (anything past the current week) should be the
result of the previous week plus the projection for the current week minus
the production quantity "ProdQty" for the current week...
Result + DistQty - ProdQty
This is so easy to write in Excel, but how can I write this in Access?
Thanks in advance!
James C.
I've read other posts, but can't quite get my query to do show what I want.
Perhaps I'm still trying to get my brain around the idea.
I have a query that shows the projected sales quantity of a given item, given
month, given week, that week's start date, that week's end date, and given
warehouse. The field name that shows the quantity is called "DistQty". I
also have a query that shows the current on hand quantity for the item and
the warehouse. This field is called "QtyOnHand". I can easily subtract the
two to get a suggested production for my current week, but I need to project
the production for 12 weeks out..Here is where I get lost.
The projected production (anything past the current week) should be the
result of the previous week plus the projection for the current week minus
the production quantity "ProdQty" for the current week...
Result + DistQty - ProdQty
This is so easy to write in Excel, but how can I write this in Access?
Thanks in advance!
James C.