<div>
I used &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <a href="https://www.experts-exchange.com/questions/26833591/Querry-Help.html?anchorAnswerId=34933741#a34933741" rel="ugc">https://www.experts-exchange.com/questions/26833591/Querry-Help.html?anchorAnswerId=34933741#a34933741</a><br />
<br />
Worked very well<br />
<br />
Thanks
</div>


I used           https://www.experts-exchange.com/questions/26833591/Querry-Help.html?anchorAnswerId=34933741#a34933741 [https://www.experts-exchange.com/questions/26833591/Querry-Help.html?anchorAnswerId=34933741#a34933741]

Worked very well

Thanks

<div>
<div class="content wysiwyg-content">
Hi,<br />
As example, suppose I have a table, with 2 fields, ClientNo and ProductNo<br />
&nbsp; &nbsp;<u>ClientNo</u> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <u>ProductNo</u><br />
&nbsp; &nbsp; &nbsp; &nbsp;client1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; productA<br />
&nbsp; &nbsp; &nbsp; &nbsp;client1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; productB<br />
&nbsp; &nbsp; &nbsp; &nbsp;client1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; productC<br />
&nbsp; &nbsp; &nbsp; &nbsp;client2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; productB<br />
&nbsp; &nbsp; &nbsp; &nbsp;client3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; productA<br />
&nbsp; &nbsp; &nbsp; &nbsp;client3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; productC<br />
<br />
I would like to create a query where the result should be:<br />
<br />
&nbsp; &nbsp;<u>ClientNo</u> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<u>Product</u><br />
&nbsp; &nbsp; &nbsp; &nbsp;client1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; productA, &nbsp;productB, &nbsp;productC<br />
&nbsp; &nbsp; &nbsp; &nbsp;client2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; productB<br />
&nbsp; &nbsp; &nbsp; &nbsp;client3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; productA, &nbsp;productC<br />
<br />
How can I do it without using a temporary table?
</div>
</div>


Hi,
As example, suppose I have a table, with 2 fields, ClientNo and ProductNo
   ClientNo             ProductNo
       client1                 productA
       client1                 productB
       client1                 productC
       client2                 productB
       client3                 productA
       client3                 productC

I would like to create a query where the result should be:

   ClientNo            Product
       client1                 productA,  productB,  productC
       client2                 productB
       client3                 productA,  productC

How can I do it without using a temporary table?

Create an Access query

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.