Avoiding duplicate rows in a report

[deshamilton]

I have set up a database with 3 tables:

student(student code, forename, surname, year)


student and group (student code, teaching group)
lesson(date, lesson code, staff, location, teaching group)

It is possible for more than one member of staff to be allocated to the same lesson (ie shared teaching)

I want to print timetables for students and for staff. The staff ones aren't a problem but the way the database is structured, a student has two (or more) lines for any lesson where there is two (or more) staff. Is it possible to have the student timetable report configured to list the staff if there is more than one rather than printing a line for each one? Or is there another solution?

[June7]

Options:

1. report Grouping & Sorting

2. subreport

3. VBA code to concatenate the staff into a single string http://allenbrowne.com/func-concat.html