sort and group problem in a report

G

Guest

I have 3 tables for a food bank: Client (details for household); Client
history (dates, food parcel details, etc); Person (details for each
individual in the household).

I have a Client history report that displays the way I want: Client contact
information as a header, then history details by date in one block.

I have a Household details report that should follow the same display:
Contact info as header, followed by names, ages, etc for each member of the
household. But it repeats the header for each person - I can't get the names
to group.

As far as I can tell the settings for each report are identical - I created
the 1st then modelled the 2nd on it. Any ideas?


PeterK
 
A

Allen Browne

Open the report in design view.

Open the Sorting And Grouping dialog (View menu).

You should have the Group Header on the field that uniquely identifies the
household, such as HouseholdID.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filtering a report linked to a single record in a form 4
Restart page in a report 3
Conditional printing of fields 2
Report - Sorting and Grouping 1
group header and details 3
not all member in the same page 6
Multi level grouping in a report 2
Report Headers Mis-Matched from detail on report 1

Top