I
IAJG
I'm working on an inventory db in Access2000 and it's come up that the better
way for valuating my stock items would be to use the FIFO(1st-in,1st-out).
Is there any suggestions someone could make - I was thinking an update query
to update a table but the tricky part is getting the info from the purchases
into a query, I've been trying DSum, DLookup and various iif statements but
I'm running in circles now.
Thanx
way for valuating my stock items would be to use the FIFO(1st-in,1st-out).
Is there any suggestions someone could make - I was thinking an update query
to update a table but the tricky part is getting the info from the purchases
into a query, I've been trying DSum, DLookup and various iif statements but
I'm running in circles now.
Thanx