AnsweredAssumed Answered

SQL

Question asked by DylanPaschall on Aug 10, 2016
Latest reply on Aug 12, 2016 by philmodjunk

I made a Database to use for a check in/out system with some of my audio equipment and want to find a way to automatically calculate the amount of empty fields in the "Date Checked In" Column in my "list" Layout so that I know how many units are still in use and wan to insert that count into the "Currently Checked Out" Field on my "script Table" layout. I attached the Manage Database window to show what the fields are and what kind of field they are. I also attached a Picture of my "Script Table" Layout and my "List" Layout which is where I want to get the Calculations from.

 

When someone goes to check the unit back in, I type the serial number in into a find request and it automatically timestamps the field on the most recent record which marks it as "checked In"

 

There currently is 1 unit that is still out because there is nothing in the Date Checked in field.

Outcomes