Show multiple records in one field using SQL
Posted on 2007-04-03
I'm running an Access front end and a SQL backend. I have tblDaily and tblRooms. There is a one to many relationship. The fields in tblDaily can have multiple rooms. I want to display 3 fields (Facility, Elevation and Area) from tblDaily but also the multiple rooms from tblRooms all in one field on a report.
Ex: Facility, Elevation, Area, Rm1, Rm2, Rm3
I found Function fncConcat() example code on Expert Exchange but it doesn't work for me because my backend is SQL Server. Can anyone offer any other suggestions? Please?