Getting Select Query Result in a single row MS Access 2010

Asked Jan 15 '16 at 07:53

Active Jan 15 '16 at 07:53

Viewed 240 times

I am trying to get select query result in a single row, but its giving me a syntax error Here is the query

SELECT csv.ControlKey+'|' +csv.ControlName+'|'+fs.SheetName+'||' AS Result
From CSVData as csv
Inner Join FilesSheets as fs
ON csv.FileId=fs.FileId
AND csv.SheetNo=fs.SheetNo
Where csv.FileId='(20101010)20Y-27-22170_4Ä¦_20151215101623.xls'
For xml path('')

Here is the syntax error

But if I remove For xml path('') from query it works fine but return multiple rows

asked Jan 15 '16 at 07:53

AddyProg

2,960
13
59
110

becoz `For xml path('')` belongs to `Sql Server` not `Ms-Access` – Pரதீப் Jan 15 '16 at 08:16
1

Check here http://allenbrowne.com/func-concat.html to do this in Ms-Access – Pரதீப் Jan 15 '16 at 08:19
Possible duplicate of [Combine values from related rows into a single concatenated string value](http://stackoverflow.com/questions/13278590/combine-values-from-related-rows-into-a-single-concatenated-string-value) – Gord Thompson Jan 15 '16 at 17:17

Getting Select Query Result in a single row MS Access 2010

0 Answers0