Thanx for the reply Bob. I would love to be able to do this but the user insists on the layout being like my example. Have a look at Roxanne's reply...it works great.
>>I need to put together a report that will print from a course table and an evaluation table. The common field for both would be a student number. The format of the report needs to show the student name (grouped on this), then line items of course info and then line items of evaluation info. Below is an example:
>>
>>Colin Magee
>> Course1 01/01/1998 ........
>> Course2 04/01/1998 ........
>>
>> EvaluationA 04/15/1998 .......
>> EvaluationB 05/01/1998 ........
>>
>>Any help on how to do this would be greatly appreciated. TIA
>
>Colin,
>
>If you don't mind the data in columns it is pretty simple to do...
>
>Just group on master.sutdent (whatever that may be)... IN the group header put the students name, id, etc... Relate that file to the course file and the evaluatin file...
>
>Then, in the detail layout the info from the two files...
>
>Course1 Date Blah Blah Blah Evaluatin A alkdjf alkd fadlkfj
>
>It works fine, if you use Legal/Landscape and a 10 or 8 point font you can fit alot of data on the report.
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada
cmagee@metroland.comNever mistake having a career with having a life.