>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