Is there a function/query that will allow multiple returned rows to be combined into a single field? I’m looking thru the PO Tables and finding all PO numbers for a specific job. The job may have 3 POs. PO Number : Job Number 70001 : 00245 70010 : 00245 70008 :…

BAQ: Calculated Field Concatenate Rows to single field

josecgomez (Jose C Gomez) June 2, 2017, 7:43pm 5

Here is an example @WesAtITC
CustOrder.baq (17.6 KB)

27 Likes

Multiple lines in BAQ to consolidate into 1 line item

BAQ incorrect syntax near 'FOR'

SQL help! Comma separated operations list by assembly using FOR XML PATH

BAQ with Subquery

Top 5 Products sold