Using a loop to concantenate strProjectManger from multiple record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Access 97

I have a query that includes (among other things) the field
strProjectManager. I want to have Access concatenate the different project
managers so I can use the final string as part of a header in a report.

I realize that I have to do a loop function; I just have no idea how to
write this and report the result out as a field in a report.

Any help is greatly appreciated.
 
charliesangels said:
Access 97

I have a query that includes (among other things) the field
strProjectManager. I want to have Access concatenate the different project
managers so I can use the final string as part of a header in a report.

I realize that I have to do a loop function; I just have no idea how to
write this and report the result out as a field in a report.
Click to expand...


Here's a popular function to do that:

http://www.rogersaccesslibrary.com/...Generic Function To Concatenate Child Records'
 
Back
Top