Hello,

I need to duplicate a table that's in a Access database through VB 2008. Allow me to give the run down of what i'm trying to achieve here before I ask for help, as I may not be doing this in the most efficient way possible.

My program is a student attendance logger that allows students to come by, and either scan their ID badge or type their 6 digit code. When they do this, the program will successfully mark them as attending, and also mark the time they signed in on the table. (see photo)
Name: Table 1.jpg Views: 425 Size: 8.9 KB

My issue is that after the day is over, the data from the past day is still in that table. If the old data remains, there is not a way to keep a daily record of attendance as it will simply be overwritten.

To solve this, my first solution would be to have the program create a new table at startup that includes all the names and ID numbers of the students from the original table, but removes the times they clocked in and their attendance status to "no". That seems like the most redundant way to do it.

My next option would be to use the one table, but somehow have the program remove data from the columns that have the dates in them. and printing out the table at the end of each day. This would be the simplest way of doing it. But I would prefer to do it the first way.
Name: Table 2.jpg Views: 533 Size: 9.7 KB

Any help is greatly appreciated. If you have ideas on another way I can do this. Please, I am open ears.

Thank you