Report that does inventory as of a date?
I have a database that tracks our inventory of steel coils. I have another database that keeps track of inventory transactions to those coils. When a part of the coil gets used, a user creates a transaction entry to show how much metal was used and when it was used.
I want to create a report that shows how much inventory I had at any given date. This means I would somehow have to take the original weight of the steel coil and subtract only selected transactions from it. Does anyone know how I might do this? And how would I prompt a user for a date?