Combine rows?? HELP PLEASE

[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

 

[Duane Hookom]

Find the generic concatenate sample at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane