combine value in the new column

[suhascool1]

Hi,

how to join the data in the combo column.

Order Number	Schedule Line Number	Material_Code	Material Name	Confirm Qty	Combo Coloumn
1234	2	10C39	Wooden Box	2	1234,2,10C39,Wooden Box,2
1234	1	10C39	Wooden Box	0	1234,1,10C39,Wooden Box,0
3456	2	39C34	Glass	1	3456,2,39C34,Glass,1
3456	1	39C34	Glass	0	3456,1,39C34,Glass,0
9805	2	56C34	Cotton	5	9805,2,56C34,Cotton,5
9805	1	56C34	Cotton	0	9805,1,56C34,Cotton,0

Thanks

suhas 

[theoat]

Try this :
[Order Number] & ','  [Schedule Line Number] & ',' & [Material_Code] & ',' & [Material Name] & ',' & [Confirm Qty]

Kind regards,
Théo ATRAGIE.

[suhascool1]

Hi Theot

Create new column in the existing table like this

Order Number	Schedule Line Number	Material_Code	Material Name	Confirm Qty
1234	2	10C39	Wooden Box	2
3456	2	39C34	Glass	1
9805	2	56C34	Cotton	5

and this new column Combo column and join value in the column

Combo Coloumn

1234,2,10C39,Wooden Box,2

3456,2,39C34,Glass,1

9805,2,56C34,Cotton,5

[theoat · Accepted solution]

Yes, this formula do this :
[Numéro de commande] & ',' [Numéro de ligne de programme] & ',' & [Code_matériau] & ',' & [Nom du matériau] & ',' & [Confirmer la quantité]

You can try this in a table where.

Have a nice day.
Kind regards,
Théo ATRAGIE.

[suhascool1 · Accepted solution]

can you help me how can i write this query in the table

[suhascool1]

done

Thank you