Create an Access query

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?
Karl001Asked:
Who is Participating?
 
Karl001Author Commented:
0
All Courses

From novice to tech pro — start learning today.