Good afternoon all,
I am having some issues in getting this data to return to Excel.
, INGlobalInvoiceHeader_0.cono AS 'Your Reference'
, GROUPCONCAT(INGlobalInvoiceHeader_0.invno) AS 'Invoice Details' "there is a _ between Group and Concat"
, SUM(INGlobalInvoiceHeader_0.totval) As 'Total Value'
The query works in MS query and returns three columns, but when it is passed to excel it drops the 'Invoice details' column in its entirety. Is anyone able to offer some assistance?
Bookmarks