Access Attendance Tracking Table

[brikusi]

I need help building a simple Access Attendance table for me to query and build reports from. This table will only need:

PersonID
Date
Comments

However I don't want to manually enter the date each time.
I want to be able to create a form whereby the personID is already listed and i just simply mark for that day a checkbox and leave comments as needed.

I'm thinking a update query will be needed in order to add the new date of records to the same table? not sure.

I tried googling but couldn't really find one that fit my needs best and not too difficult to create.

If anyone knows how I can achieve this or knows of a link or video I can watch to do this would be very helpful.

Thanks in advance.

[twinnyfo]

Brikusi,

You haven’t given us much information to go by. We have no idea what the structure of your form is and how you are listing your people to list attendance.

Adding a date is very easy; adding today’s date is easier. But, we don’t know how you are trying to do this and you haven’t shown us what you have attempted so far, so we can’t trouble shoot anything.

We just need more information to assist.

[brikusi]

Thanks, I have re-submitted a question with more detail.