Access Attendance table help; Need to update table daily w/o copying table twice

[brikusi]

LOL

Wow! Thank you thank you! thank you!
I can't thank you enough. You don't know how much I struggled with this thing and the fact that you dedicated so much individual time to assist me means the world to me. I wish I could repay you some how. I have learned so much through this experience. The VBA is a bit confusing so I will go back later and try to decipher through it to write comments to try and understand what different parts are doing exactly. But you have been great. You're great at what you do without a doubt. Thank You sincerely.

I'm not sure which part I should mark as best answer....I wish I could do all of it but I guess I'll mark the very beginning where the idea was proposed.

[twinnyfo]

I'm glad I could be of service. when work is a bit slower than normal, I can distract myself to help others.

So pleased that things worked out. If you have any questions on what hte code does and how it works, just shoot me a note.