prabha_friend
Prabhakaran Karuppaih
- Local time
- Today, 13:15
- Joined
- Mar 22, 2009
- Messages
- 941
First let me explain how and where I use unbound forms?
Attendance register
I just store the absences only. Because it is the less occurring ones (less data)
Table structure:
Field1:ID
Field2
ate
Field3:Student_ID
How the form is made?
Now I come to report.
Why I need a Dynamic Report?
Like the user wanted the Attendance Form in that old age register way. He is asking many reports in the same old age credit and Debit method along with his own data visualizations.
currently I am creating an excel workbook and showing his categorized data on different sheets of the workbook.
My current problem is: How can I create a second page in an unbound report?
I have attached the Excel files having the data reported on. How to make it rendered on an Access Reports? Possible?
Please help. Thank you.
Attendance register
I just store the absences only. Because it is the less occurring ones (less data)
Table structure:
Field1:ID
Field2

Field3:Student_ID
How the form is made?
Code:
For each Student in ThisClass
For each day in ThisMonth
create comboBox next to yesterday's combo
Next Day
Next Student
How I read the Data?
For each Student in ThisClass
For each day in ThisMonth
If Student_Day's comboBox is checked then
Update a record in that table
end if
Next Day
Next Day
Now I come to report.
Why I need a Dynamic Report?
Like the user wanted the Attendance Form in that old age register way. He is asking many reports in the same old age credit and Debit method along with his own data visualizations.
currently I am creating an excel workbook and showing his categorized data on different sheets of the workbook.
My current problem is: How can I create a second page in an unbound report?
I have attached the Excel files having the data reported on. How to make it rendered on an Access Reports? Possible?
Please help. Thank you.