I have created a BAQ to list multiple PO Numbers in one Row, separated by a comma as follows: [image] I created this as follows: [image] [image] [image] SQL Query Phrase: select [OrderDtl].[OrderNum] as [OrderDtl_OrderNum], [OrderDtl].[PartNum] as [OrderDtl_PartNum], [OrderDtl].[LineDe…

I figured it out! I had to add a SubQuery Criteria (not Table Criteria), and I had to order it before the “FOR XML PATH” expression. Now it’s working perfectly. Thanks for the help! [image]

Concatenate multiple rows into one row, with criteria

Epicor ERP 10

Banderson (Brandon Anderson) January 8, 2019, 3:08pm 6

Check out this thread. @josecgomez posted and example BAQ in there that you can look at.

1 Like