I am attempting to create a detailed Ending Inventory Report for the FIFO method. I have a beginning inventory table, a puchases table, and a sales table. How do i get the daily sales to be "used up" against the next layer of purcheses. I tried a "FindNext" function as a macro, but that does not work. Has anyone created a FIFO ending inventory report in access?