By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,089 Members | 2,283 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,089 IT Pros & Developers. It's quick & easy.

Access Attendance Tracking Table

P: 44
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.
Mar 8 '19 #1

✓ answered by 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.

Share this Question
Share on Google+
2 Replies


twinnyfo
Expert Mod 2.5K+
P: 3,284
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.
Mar 9 '19 #2

P: 44
Thanks, I have re-submitted a question with more detail.
Mar 11 '19 #3

Post your reply

Sign in to post your reply or Sign up for a free account.