sort and group problem in a report

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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.
 
Back
Top