Set record column as a heading (1 Viewer)

I have a query feeding a report that shows an individual with different Courses and dates. On the query it shows each certificate as a record. E:G

Joe Bloggs, Induction, 10/01/19
joe Bloggs, First Aid, 12/02/18
Joe Bloggs, Manual Handling, 05/11/17

I am looking for a way to show this on a report as follows

Name Induction First Aid Manual Handling

Joe Bloggs 10/01/19 12/02/18 05/11/17

Ca this be done on the query or report?

You could use a crosstab query as the record source for a sub report in the header section.
There may be other solutions as well

isladogs said:

You could use a crosstab query as the record source for a sub report in the header section.
There may be other solutions as well

Click to expand...

Thanks for the pointer.. got this working by creating the cross tab query with value grouped by "last". This gave all values on the same line and i simply added this query to the existing query feeding the form then added the fields.

Thanks Again