Progressive qry

[Jason Kaufman via AccessMonster.com]

I am wondering if it is possible to write a query that will do the following:

OnHand - SalesQty1 = OnHand1
OnHand1- SalesQty2 - OnHand2
OnHand2 - SalesQty3- OnHand3
etc.

This goes hand-in-hand with the question I asked this morning which I havent
seen any answer for yet.

Thanks for whatever you are able to offer!

 

[[MVP] S.Clark]

I answered the morning one, I think.

Short answer: Do it with more than one query.

 

[Jason Kaufman via AccessMonster.com]

hmmm...ok, though not sure how i would do this to make it work.

I answered the morning one, I think.

Short answer: Do it with more than one query.

I am wondering if it is possible to write a query that will do the
following:

[quoted text clipped - 9 lines]

Thanks for whatever you are able to offer!

 

[Jason Kaufman via AccessMonster.com]

Keep in mind that the changing OH quantity I need to track will be for each
individual item# for different SO# that may occur within a specified date
range.

I answered the morning one, I think.

Short answer: Do it with more than one query.

I am wondering if it is possible to write a query that will do the
following:

[quoted text clipped - 9 lines]

Thanks for whatever you are able to offer!