Dear all kindly assist me in doing this. I have data in a table which look like below
DATE DESIGNCODE TRAINEE
01/08/2019 D0D23 1001
01/08/2019 D0D24 1001
02/08/2019 D0123 1002
02/08/2019 100RT 1002
I need a query to present it like below in a report. I have tried crosstab queries. Maybe my approach was wrong :banghead:
DATE TRAINEE DESIGNCODE1 DESIGNCODE2
01/08/2019 1001 D0D23 D0D24
02/08/2019 1002 D0123 100RT
Like this
Thank you and Regards.
DATE DESIGNCODE TRAINEE
01/08/2019 D0D23 1001
01/08/2019 D0D24 1001
02/08/2019 D0123 1002
02/08/2019 100RT 1002
I need a query to present it like below in a report. I have tried crosstab queries. Maybe my approach was wrong :banghead:
DATE TRAINEE DESIGNCODE1 DESIGNCODE2
01/08/2019 1001 D0D23 D0D24
02/08/2019 1002 D0123 100RT
Like this
Thank you and Regards.
Last edited: