Using a loop to concantenate strProjectManger from multiple record

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.
 
M

Marshall Barton

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'
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Loop to export report and email to each person 1
Loop Question 2
Emailing multiple reports in Access 0
Access Dcount (multiple criteria) 3
Do loop syntax 7
Need to loop all records in a table - run query, print & email reports 1
Can't create a report from my query in Access 1
Loop through fields on form, simply with values from array 4

Top