MS Access Query Concatenate Multiple Row Values Into A Single Row Or Field Used For Many Images For A Single Product
Posted on 2016-11-27
I am lost on this one. I am working on queries for an export file. I have Products and each Product can have several photos maybe even 12 or so. Each Image for a single product has a file name. Example:
SkuID 777 has 3 photos.
How can I create a query with a concatenated field with the File Names into a single row. Also with a separator such as (, or |).
These need to be grouped by SkuID.
Table is ProductImages
Fields ProductImageFileNm and SkuID