M
mccloud
We have an ERP system that stores monthly qty's sold information by item. So
Nov 2009 is period 23. Jan 2010 will be period 01. Query will work from a
form where user will enter number of past periods to review and the item.
(.e.g. 6) entering 6 would need to add periods 22 thru 17. I thought about
building a table with (if period = 23 then add these periods together but it
would need to be huge to consider all possible combinations. Any one have a
better way?
Nov 2009 is period 23. Jan 2010 will be period 01. Query will work from a
form where user will enter number of past periods to review and the item.
(.e.g. 6) entering 6 would need to add periods 22 thru 17. I thought about
building a table with (if period = 23 then add these periods together but it
would need to be huge to consider all possible combinations. Any one have a
better way?