How to FIFO calculation in Access

[SF]

I would appreciate if anyone suggest step in FIFO calculation

I have the following information store in table

ProductID Type Date Qty UPrice
1223 Purchase 1/1/05 100 56
1223 Sold 5/1/05 20 58

Regards

SAM

 

[Guest]

I assume that FIFO means First In First Out. To me that is not a
calculation but a matter of tagging the items with a date or batch number
that relates to date received so as to issue/sell the oldest items first.

How do you mean it?

 

[SF]

That correct. FIFO means First In First Out. I still cannot find the way to
TAG the purchase and Sales info together. Anyway, I will try combining these
info together. Thank you.

SAM

 

[wangyuzhao]

17 ÑϺ£Ï¼