Access Query Result in One Row (1 Viewer)

W

waqas ali

New member

Local time

Today, 06:15

Joined

Jan 8, 2017

Messages

2

• Jun 24, 2019

• #1

Hi Experts,

I want to see query result with id numbers, Count of id numbers and in third column count detail.

records are as below in table.

1234 T1
1234 T2
1234 T3

Result of query should be.

1234 count = 3 , in detail column T1,T2,T3

How can I get result in one row?

 

Minty

AWF VIP

Local time

Today, 03:15

Joined

Jul 26, 2013

Messages

10,368

• Jun 24, 2019

• #2

You'll need to concatenate the results - have a read here of the way to create a function to do what you need ;
http://allenbrowne.com/func-concat.html

 

June7

AWF VIP

Local time

Yesterday, 18:15

Joined

Mar 9, 2014

Messages

5,466

• Jun 24, 2019

• #3

ConcatRelated function can get detail column. An aggregate query can get count.

SELECT ID, Count(*) AS CountRecs, ConcatRelated(…) As Details FROM table GROUP BY ID, ConcatRelated(…);