Report from query where constants are summarised, variables are detailed

[notfound]

Hello all,

I am logging the supervision of counselling staff. Each week, a counsellor meets their supervisor to discuss their client caseload.

I need to generate a report that summarises clients discussed in the previous session.

I've created a query that pulls all this together. The query contains 10 records, where some things are constant (supervision_date,supervisor,counsellor) and the rest varies with each client discussed (clientID,clientName,summary)

I would like my report to have a summary section with the constant info, and a row for each of the clients):

Constant summary info
Date: [constant]
Supervisor: [constant]
Counsellor: [constant]

Varying info:
1. ClientID Name Summary
2. ClientID Name Summary
...
10. ClientID Name Summary


Thanks for your time,
nf

 

[Scooterbug]

You can use the Sorting and Grouping to acheive what you want. Set it so that it sorts by Client ID. Also set the Group Header to Yes. You can then put the Client information into the area under the Header for the clientID.

 

[notfound]

Thanks again Scooterbug, I knew it should be simple enough.