i have combined Query, as below
ItemCode ItemName Qty OrderNo
100356 xxx 2 001
100355 yyy 3 002
100356 xxx 5 003
Currently the group query shows as below:
ItemCode ItemName Qty
100356 xxx 5
100355 yyy 3
I want to show as the following:
ItemCode ItemName Qty OrderNo
100356 xxx 5 001,003
100355 yyy 3 002