qry difficulty

[Jason Kaufman via AccessMonster.com]

I am wondering how to write a query (if its possible) that will do the
following
Take a Sales Order # within a specified date range (which I have done) and
then take each inventory # within that Sales Order # and subtract the Sales
Order quantity from the current On Hand quantity (which I have done, i think)
but then I want this revised On Hand quantity to be used for any subsequent
Sales Orders that may use that Item Number. So I can show a continually
revising OH quantity as the date & Sales Order# changes.

Below is a sample table of what I need to track

Sales Order Date OnHand Sales Order Qty Revised OH item#
1 10/25 100 5
95 A
1 10/25 20 1
19 B
2 10/25 40 4
36 C
3 10/26 95 10
85 A

I have created a query that has all the data there, I just havent figured out
how to show it as represented in the table above. Any help would be greatly
appreciated.

 

[[MVP] S.Clark]

I would do this in a 2nd query, such that it has time to calc the OnHand.

 

[Jason Kaufman via AccessMonster.com]

I am not sure how to do this, any suggestions on writing this (non-SQL) would
be greatly appreciated as I have been struggling with this for several days.

I would do this in a 2nd query, such that it has time to calc the OnHand.

I am wondering how to write a query (if its possible) that will do the
following

[quoted text clipped - 25 lines]

greatly
appreciated.