Select data for continuous records in a report

For the report in question all data is taken from one table named "Completions £". The fields I will be using are as follows:

Code:

---

[Surname]

[Firstname]

[Branch]

[Quarter1_A]

[Quarter1_T]

---

When the records are added, the Branch is added using a combo box. There can be several rows of data with the same Firstname and Surname but with different Branches.



The report layout must look something like this:





I have tried using DLookup to select the data based on the data in the Name text box, but this just gets the first result and duplicates it.



Any help would be greatly appreciated!

Attached Images

Question3img1.PNG (11.2 KB)

Select data for continuous records in a report