Search results

Yes, I did. It seems to have worked. Thank you!

The structure is like this. I have a table for all the people who can check items in and out. I have a table that has all of the items that can be checked in/out. I have a table that has the assignment, which contains the the date for in and a date for out.

I have setup a database in which is similar to checking in/out a library book. Everything is working fine except 1 very important query. I want to be able to run a query that shows me all items that are currently in inventory that are available to check out. It seems simple on the surface as I...