more than one details

[iccsi]

I need generate a report for different information like students
grades and attendance information.


the report is like following

student ID
student name


Grade Report:

Courses Grade
math A
Englisg B
Science A


Attendance:

Date Reason
05/05/2008 Sick
04/01/2008 Late
01/05/2008 Weather Exception

Rewards:

Date Activity Prize
02/05/2008 Swimming competetion Bronze
01/05/2005 Tennis Gold


Valunteer:


Date Group Hours
01/01/2008 Church 5


Is it possible to have all the details report in one report details?
They are different columns and different information, but belongs to
one student. I would like to have all information in one report.


Is it possible? Does MS Access support this?


Your help is great appreciated,

 

[Klatuu]

This is a case where you will need to use sub reports. A report, like a
form, can have only one record source.

 

[iccsi]

This is a case where you will need to use sub reports.  A report, like a
form, can have only one record source.
--
Dave Hargis, Microsoft Access MVP












- Show quoted text -

Thanks for the information,
Do you have any example link?
Thanks again,

 

[Klatuu]

If you go to www.msdn.com and search for subreports, you will find info on
how to build a subreport. I can't give a specific link because you didn't
say what version you are on.

 

[iccsi]

If you go towww.msdn.comand search for subreports, you will find info on
how to build a subreport.  I can't give a specific link because you didn't
say what version you are on.
--
Dave Hargis, Microsoft Access MVP






- Show quoted text -

Thanks for the info,