Question Locked
0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I'm trying to create an daily attendance database with "Present", "absent", & "absent with apology" as the attendance field entries, that field should have the current date as the title,also is it possible to generate an excel worksheet report after seven days through a command button on a form?(attendance columns are the only changing fields) The other static fields in my table are "name" and "location". Please help!
3 replies
by bssiberia Accepted solution
Clarifications
by tony hopkinson Accepted solution
Your table should be
PersonID, Status, Date
1 Present 2010-07-12
1 Present 2010-07-13
1 Absent 2010-07-14
1 Absent 2010-07-15
1 Absent 2010-07-16
To get your data for the spreadsheet, use crosstab, excel has it's own so it might be easier to do it in there.
But crosstab tab would give you
Person 2010-07-12 2010-07-13 .. 2010-07-16
1 Present Present Absent
by bssiberia Accepted solution
Thanks Tony, although i still can't figure out how I'll come up with a report indicating a week attendance for about 60 people, I'm still new in VB and database programming
This discussion is closed to new replies.
Trending Software posts
Sort by Trending
1 helpful
1 reply
Question Unanswered
How Are Teams Testing AI-Generated Code Before Production?
0 helpful
0 replies
0 helpful
5 replies
0 helpful
20 replies
Discussion
Is There any Reverse Video Search Tool
0 helpful
8 replies