How to create an Unbound Report in a Dynamic Way?

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:Date
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.
 

Users who are viewing this thread

Back
Top Bottom