Concatenated records in a subreport

[laser93069]

I have a report which shows a comma seperated list of all
records in a category and it works perfectly.
See "Microsoft Knowledge Base Article - 210163
ACC2000: How to Concatenate Data from the 'Many' Side of a
Relationship" for this example.

Problem: When I embed this report as a subreport the
concatenated list is doubled. For example, the
concatenated list should show something like this:

Division: 1 Territory: A, B, C, D, E

but when I embed this report into the Report Footer of
another report, the report shows:

Division: 1 Territory: A, B, C, D, E, A, B, C, D, E

Any suggestions?
Thanks in advance.

 

[Marshall Barton]

I have a report which shows a comma seperated list of all
records in a category and it works perfectly.
See "Microsoft Knowledge Base Article - 210163
ACC2000: How to Concatenate Data from the 'Many' Side of a
Relationship" for this example.

Problem: When I embed this report as a subreport the
concatenated list is doubled. For example, the
concatenated list should show something like this:

Division: 1 Territory: A, B, C, D, E

but when I embed this report into the Report Footer of
another report, the report shows:

Division: 1 Territory: A, B, C, D, E, A, B, C, D, E

That article accumulates values from multiple records in
event procedures. This approach is notoriously unreliable
and will fail in all kinds of situations.

Instead, you should use one of the many functions that have
been made available on newsgroups over the years, You can
google for DConcat, or try one of these:
http://www.mvps.org/access/modules/mdl0004.htm

http://www.rogersaccesslibrary.com/...Generic Function To Concatenate Child Records'

 

[laser93069]

THANK YOU!

I used Duane Hookum's code and it worked excellent.