summarizing memo fields

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

Guest

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.
 
Back
Top