I need to write a FM program that will keep track of people coming in and out of our office.

We have a card reader that automatically enters name, address, etc into the specified fields.

That works fine.

The trouble I am having is this.

I have assigned every entry a status to 0

I also want to keep record of every time someone checks in and out.

So if the status = 0 they are checked out, and if status = 1 they have checked in.

It's kind of like a time clock that I need to build.

So what I was thinking was:

1. Scan card

2. Find to see if that person has already checked in that day

3. If they have checked in, message saying you have already checked in.

4. If they havent checked in, then the record is entered and the status is switched to 1

Does this make any sense.

Anyone know what I should do here?

Thank you in advance.

Peter

I also want to keep record of every time someone checks in and out.

Your method would only indicate the current status, with no trail. If you really want to keep track, you should create a new record when the card is swiped.

IIUC if the person isn't (for some reason) checked in and they want to check out, they must swipe the card twice? Or can they interact with the solution another way (e.g. buttons, touchscreen, etc.)?

Edited December 16, 201015 yr by comment

Your method would only indicate the current status, with no trail. If you really want to keep track, you should create a new record when the card is swiped.

IIUC if the person isn't (for some reason) checked in and they want to check out, they must swipe the card twice? Or can they interact with the solution another way (e.g. buttons, touchscreen, etc.)?

I only want it to make a new record if a current record on that date is not checked in.

I only want it to make a new record if a current record on that date is not checked in.

That is possible, too - you would open a new record on checking in, and "close" it on checking out. However, you still need to handle the case where a person forgot to check in or to check out.