First In First Out

[acecraig100]

I need to find a way to compute the balance and value of inventory on hand in
a FIFO accounting system. I have the following report in access.

strategy month year date quantity transaction price
notes
Contract Cattle
March 2007
08-Jan-07 35 Purchased $90.00
08-Jan-07 40 Purchased $91.00
08-Jan-07 10 Purchased $91.25
08-Jan-07 20 Purchased $91.50
09-Jan-07 -40 Sold $91.25
09-Jan-07 -10 Sold $93.00

I need for this report to show the balance remaining of my inventory. In
this example, I sold 50 of the 105. I need to find a way to have a way to
show the balance at the end of this report as:

Balance
25 at $91.00
10 at $91.25
20 at $91.50

I know that I will need VBA but not sure where to start.

Thanks for your help,

 

[Al Campagna]

acecraig100,
Do a Google Access groups search on "First in first out".
There are many hits on this subject. Try those first, and get back if you still have
issues.
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."