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.

What can I do ?