Display text from one memo field and multiple records in a report

[jereece]

I have an Access database where we grade reports. At the end of the grading form I have a memo field [Comments] for the grader to enter comments about why the report received the grade [Grade]. Each report is graded by multiple people. So for example, ReportNum 08-001 may be graded by 5 people and therefore will have 5 records in the database. I need a report to show all the comments for all the reports where the grade is <80. I know how to do this except for how to display all the comments from the memo field in the 5 records on one report for that ReportNum.

I hope I am making sense. I appreciate any help.

Jim

 

[jereece]

5 days with no response, so I am just replying to get back to the top.

Thanks,
Jim

 

[georgedwilkinson]

You need a text concatenate aggregate function. Unfortunately, Access doesn't have one, so you need to write your own in VBA.

When I, in astonishment, found that I had to do this myself, I found a sample through a google search. Unfortunately, I can no longer find the link. I have the code from earlier but I'm reluctant to post it because there is no author or copyright information. If you're interested, PM me and I'll e-mail it to you.

It is interesting to note that I spent more time on this issue than I did any other single problem in my career. I'm just saying that because I want you to understand that, even with someone else's code and an idea of how to do it, it still isn't easy.