Hey all, so what I'm trying to do is set up an accountability system for people that I have to manage (about 120 to 150 people every day). Every person has an ID card that we can scan that gives us their names, along with some other string of numbers that are specific to that card. For the purpose of accountability, I need to scan their cards before they leave and when they come back from various places. What I need is some sort of way to scan their cards that registers that card has been scanned, and then time stamps what time it was scanned. Also since I need to get accountability of them multiple times a day I need to make sure that the system can look back and see if that person's card was scanned earlier in the day, so it doesn't create a duplicate entry further below. If it was scanned earlier in the day then it needs to add another timestamp in the next column over in the same row as before so I know they checked in for that accountability time, and then I can go and find that person to make sure they aren't missing.
Does anyone have any successful ways of implementing this? It could be in an Access Document, and Excel Sheet or some other type of program that would be free. I also need a way to print out the sheet at the end of the day and file it for records. If anyone knows how to do this or some pointers on how to get started that would be awesome. Thank you!
Does anyone have any successful ways of implementing this? It could be in an Access Document, and Excel Sheet or some other type of program that would be free. I also need a way to print out the sheet at the end of the day and file it for records. If anyone knows how to do this or some pointers on how to get started that would be awesome. Thank you!
Facebook
Twitter