I have a database that tracks inventory by creating a new record (changing the status from Checked Out to Checked In and placing the current date) when a piece of inventory is checked out and then creates another record when the inventory is checked in. I would like it to add the checked out date to the original record, and only create a new record when the piece of inventory is checked out again.
Reason being is I would like to have a query is shows Checked In date Is Null so it only displays items currently Checked Out. Right now it will show ALL previous records of the item being Checked Out.
Any additional info please ask. Thanks!