>>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:
>
>How about building a cursor using a Select statement and doing the report off of the cursor?
>
>Ed
Thanx. Please see my reply to Roxanne.
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada
cmagee@metroland.comNever mistake having a career with having a life.