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?
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?