Multiple records into one record (1 Viewer)

Lochwood

Registered User.
Local time
Today, 10:01
Joined
Jun 7, 2017
Messages
130
I have employees with certain tasks completed and each task creates a new record. I am looking to change the format so all tasks run as colums across the top and have created a crosstab for this purpose but it creates multiple rows for the employee. is there a way to merge the data into a single record/Row?

I need to export this data to a spreadsheet in this format.

EG: Employee 30 would look like
30 | 02/06/2070 | 02/06/2022 | 24/08/2023 | 02/06/2070 | 09/06/2022 | 02/06/2070 | 25/05/2067 | 28/04/2023 |

The number on the left is employee and the date is the task. each task has a separate column created by the crosstab query.


1620894945555.png


Any Help much appreciated.
 

Minty

AWF VIP
Local time
Today, 17:01
Joined
Jul 26, 2013
Messages
10,354
What is the SQL for the current query?

What format is the data in originally? Do you have a small sample?
 

Gasman

Enthusiastic Amateur
Local time
Today, 17:01
Joined
Sep 21, 2011
Messages
14,044
I would use Allen Browne's Concatenate function.?
The DBGuy also has a function called SimpleCSV I recall?
 

Minty

AWF VIP
Local time
Today, 17:01
Joined
Jul 26, 2013
Messages
10,354
I'm fairly certain you can do this in a cross tab, it just needs setting up correctly, hence wanting to see how the data is stored.
 

Users who are viewing this thread

Top Bottom