I have an inventory table that contains some inventories and a sub table that contains check in and check out records.
I'm trying to create a qry that will open a form to show the latest inventories that have been checked out but not checked in.
I do have the dates and time of check out with unique id's.
Does any one have any ideas on how to do this?
Thank you ahead of time.
I'm trying to create a qry that will open a form to show the latest inventories that have been checked out but not checked in.
I do have the dates and time of check out with unique id's.
Does any one have any ideas on how to do this?
Thank you ahead of time.