Hi Claude! Make group in report by office and staff initial. Drop all field from first table and the staff name from second table to detail band. Mark Staff initials and name as Supress repeated value within second group. * Beggars cannot be choosers >I have a table which contains accounting data. In that table I have a field >which contains the responsible branch office and another field for the >staff initials. In a second table (staff) I have the staff initials with >the corresponding staff name. > >I would like to have a report which shows the revenue for each staff member >within a branch. I have the first table ordered by office+staff_initials to >do this grouping and everything is ok but I would like the name also >printed in the report that is associated with the staff initials.