J
JonSiii
Hello...
I'm trying to create a report of projected changes in inventory across a
range of dates, beginning with a given starting point. I have simulated
changes to inventory (IIn's and Out's) and want to show the results in a
table of this format:
Item 4/17 4/18 4/19 ...
Previous 100 75 84
In 10 22 15
Out 35 13 7
Current 75 84 92
I have the starting "Previous" value on 4/17, the "In" and "Out" values for
each date, and I need to calculate the "Current" for each date and then roll
that number into the following date's "Previous" column (piece of cake in an
Excel Spreadsheet).
Is there a way to accomplish this with a series of queries? Once I have all
the calculations completed, I plan to use a Cross-Tab to generate the actual
query results. (Data would be in the format: <Item><State><Amount> where
<State> is one of Previous,In,Out,Current, sorted apprpriately.)
Thanks much for any help you can give me...jon
I'm trying to create a report of projected changes in inventory across a
range of dates, beginning with a given starting point. I have simulated
changes to inventory (IIn's and Out's) and want to show the results in a
table of this format:
Item 4/17 4/18 4/19 ...
Previous 100 75 84
In 10 22 15
Out 35 13 7
Current 75 84 92
I have the starting "Previous" value on 4/17, the "In" and "Out" values for
each date, and I need to calculate the "Current" for each date and then roll
that number into the following date's "Previous" column (piece of cake in an
Excel Spreadsheet).
Is there a way to accomplish this with a series of queries? Once I have all
the calculations completed, I plan to use a Cross-Tab to generate the actual
query results. (Data would be in the format: <Item><State><Amount> where
<State> is one of Previous,In,Out,Current, sorted apprpriately.)
Thanks much for any help you can give me...jon