Dear all, Please help me how to design table for FIFO method calculation. Thanks. Regards, Vensia
V Vensia Oct 31, 2005 #1 Dear all, Please help me how to design table for FIFO method calculation. Thanks. Regards, Vensia
J Jeff Boyce Oct 31, 2005 #2 For those of us who are not inventory specialists, could you describe what you want the table's data to include? For instance, if you want to be able to tell when an item was entered onto the table, you'd need to keep a date/time value.
For those of us who are not inventory specialists, could you describe what you want the table's data to include? For instance, if you want to be able to tell when an item was entered onto the table, you'd need to keep a date/time value.
P peregenem Oct 31, 2005 #3 Vensia said: Please help me how to design table for FIFO method calculation. Click to expand... This has standard SQL (which could be translated into Jet SQL): http://www.dbazine.com/ofinterest/oi-articles/celko33
Vensia said: Please help me how to design table for FIFO method calculation. Click to expand... This has standard SQL (which could be translated into Jet SQL): http://www.dbazine.com/ofinterest/oi-articles/celko33
