[AccessD] Reports

Martin,

Sounds like you might want to base the report on a query that
de-normalizes the data first so that Offer 1-6 are simply fields in
the dataset rather than rows in a linked table.

Steve Erbach
Neenah, WI
USA

On Fri, May 30, 2008 at 4:37 AM, Martin W Reid <mwp.reid at qub.ac.uk> wrote:
> 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