Query Update

[shimul]

Hi all,

I have query where I am getting result fine, but it repeating value (Please see attachment).

However, I dont wanna repeat value.

Can you please give me idea how I can do it?

Thank you in advance.

Shimul

 

[Bilbo_Baggins_Esq]

if you remove the "Number" column from your group by query, you'll get the first two columns of your deisred result.

however, building the third column, with the concatenated numbers is a different issue.
I'm not really even sure if you could do that from within queries.
May need to write some code to build that end result.

 

[shimul]

Thank you for your reply.

Do you have any idea what will be the code to get desire result?

if you remove the "Number" column from your group by query, you'll get the first two columns of your deisred result.

however, building the third column, with the concatenated numbers is a different issue.
I'm not really even sure if you could do that from within queries.
May need to write some code to build that end result.