[AccessD] Reports

Hi All

I have to create a fairly complex mailing label and I am hopeless with reports.

The data is

Number and Name (Concat values)
Offer 1
Offer 2
Offer 3
Offer4
Offer 5
Offer 6

Each Offer line has three bits of data associated. In the above example there would be 6 rows in the table.

I need to create the mailing label with the number and name at the top and the offers listed below. There can be a max of 6 offers per record. Every time I try it I get one label per row. What I need is one label for each group of records belonging to the student.

Any help appreciated

Martin

Martin WP Reid
Information Services
Queen's University
Riddel Hall
185 Stranmillis Road
Belfast
BT9 5EE
Tel : 02890974465
Email : mwp.reid at qub.ac.uk