concatenate rows of data with matching ID (1 Viewer)

[Jayce72]

I have a table with data as the following

ID text CreatedDate CreatedBy
1 my first entry 01/01/2017 Jim
2 my second entry 01/02/2017 Kim
1 my third entry 01/05/2017 Dave
2 my Forth entry 01/06/2017 John

I need my query to concatenate as follows with the earliest date first etc

ID text
1 my first entry
CreatedDate: 01/01/2017
CreatedBy : Jim

my third entry
CreatedDate: 01/05/2017
CreatedBy : Dave

2 my second entry
CreatedDate: 01/02/2017
CreatedBy : Kim

my Forth entry
CreatedDate: 01/06/2017
CreatedBy : John

Any help please

 

[essaytee]

In your query, order by ID, then by Created Date, both in ascending order. In the Query Design window, under the field name you will see a 'sort' reference (haven't got access open at the the moment), enter ASC in that field from the dropdown values available.


If the above is not what you're after, then you'll need to explain further.