Avoiding multiple pages in a report

[AChir]

I have a report which goes to various people – they each get their page. The group of people who receive the report are drawn from a pool and this changes each time it is used. On each use the data covers a period of three days (Sat, Sun, Mon) BUT this means that those involved with more than one day receive multiple reports. I need to be able to generate one report per period which gives the person’s name and says which of the three days are involved. So from a query with:
Bloggs Sat etc
Bloggs Mon etc
Jones Sun etc...
I need to combine the rows to give:
Bloggs Sat and Mon (all remaining fields are identical)
and so on

I hope that makes sense. Is there a way I can do this?

Thanks


[This message has been edited by AChir (edited 05-07-2002).]

 

[GlennL]

Using Sorting and Grouping, add a group that identifies your person, and then in the 'details' section include the 'day' fields.

Should look something like this:

{Group Header}
Bloggs

{Detail}
Sat + Other fields
Sun + Other Fields

 

[AChir]

Thanks for the thought but I have grouping set. My problem is that the detail is pretty much like a letter so I have an unbound text box including text something like:

="...you are involved on " & [Date]& " more text..."
so I really need to be able to combine several rows into one so that the whole of the detail section is not replicated. I only need to change the single [Date] to a list of all the relevant dates