Combine rows?? HELP PLEASE

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

Guest

Hi- I have two tables that are joined by a Company Key. One table has
addresses, the other report dates. I am doing a mail merge and thus need all
the report dates merged into a single column or array.

right now I get:

COCode ReportPeriod
61902 9/30/2002
61902 6/30/2003
61902 9/30/2003
61902 3/31/2004
61902 9/30/2004

I want:
COCode ReportPeriod
61902 9/30/2002, 6/30/2003, 9/30/2003, 3/31/2004, 9/30/2004

SO that Report Period can be easily merged into a word Doc.

How do I do this?

HELP
 
Back
Top