[AccessD] Reports

Just reporting back. With of line help from MAX the problem is resolved. Max did a great job with this one and thanks to him.

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
________________________________________
From: accessd-bounces at databaseadvisors.com [accessd-bounces at databaseadvisors.com] On Behalf Of Steve Erbach [erbachs at gmail.com]
Sent: 30 May 2008 11:42
To: Access Developers discussion and problem solving
Subject: Re: [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
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com