summarizing memo fields

[Mandy J.S.]

I have a summary report that is going to be done on a daily, weekly and
monthly basis. I have a comment field where I'd like to have all the
comments that are inputted by everyone to merge into one Here's an example:

Data Entry:
Week Ending = 10/7/2005
Date = 10/5/2005
Department = Cost
Task = JCS/ECS Open
Actual = 2
Comment = WBB13; S3709

Week Ending = 10/7/2005
Date = 10/6/2005
Department = Cost
Task = JCS/ECS Open
Actual = 2
Comment = S4216; WAX02

Week Ending = 10/7/2005
Date = 10/7/2005
Department = Cost
Task = JCS/ECS Open
Actual = 3
Comment = WAZ11; S5532; EJ655

In the summary report:

Week Ending = 10/7/2005
Department = Cost
Task = JCS/ECS Open
Actual = 7
Comment = WBB13; S3709; S4216; WAX02; WAZ11; S5532; EJ655

I have the actual summary all set. I just need the comment to combine like
that. Does anyone know how I would do that? Thanks.

 

[Duane Hookom]

There is a generic concatenate function with sample usage at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.