Math equations and subdatbases.

[Ann]

I am trying to creat a database for inventory using the
accounting princples for FIFO aka: First in - First out.
This means for every part I take in I have to sell the
first one at the cost of the first item I took in. The
problem is I can't seem to get the math equations down in
Access to tell the "total $ units" column to add or
subtract the sale or purchase and add it to the total
figure.

If anyone knows what I am talking about please help. I
have yet to find a database or a spreadsheet that allows
for parts inventory or specificaly FIFO.

 

[Adrian Jansen]

So you need some way of identifying the 'First' or oldest batch of product
bought, and grab the price attached to that ? Therefore add a date field to
the inwards goods table, and set the date each time you book a batch of
goods in, and of course the price. Then when you sell the goods, look in
the inwards table for the oldest date, and retrieve the corresponding price.
Is that what you want ?

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control

 

[Ann]

Yes that is pretty much it.

Ann

-----Original Message-----
So you need some way of identifying the 'First' or oldest batch of product
bought, and grab the price attached to that ? Therefore add a date field to
the inwards goods table, and set the date each time you book a batch of
goods in, and of course the price. Then when you sell the goods, look in
the inwards table for the oldest date, and retrieve the corresponding price.
Is that what you want ?

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control



.