Concatenate Text Fields in the Child Table on the Many Side

I have a report that is run based on a simple query. In the report I show two
tables, one parent, one child, with a one to many relationship. The child
table has a text field (hourly commentary) that I'd like to display as one
field in a report where each daily activity doesn't include 24 line items,
but combines all 24 comments into one field displayed in the report in just 1
row, not 24. I'm told I need to use VBA to accomplish this but am not clear
how. Should the VBA code create a temp table with my query that then counts
row by row to compare key fields, then concatentate that field and store it
to a variable which I then write out to my report line by line? How do I
invoke that vba code (at what point, which event). Is there an mvp site you
could refer me to with an example of what I'm trying to do? TIA

There is a generic concatenate function and sample usage at
http://www.rogersaccesslibrary.com/O...p#Hookom,Duane.

--
Duane Hookom
MS Access MVP


"headly" wrote in message
news
I have a report that is run based on a simple query. In the report I show
two
tables, one parent, one child, with a one to many relationship. The child
table has a text field (hourly commentary) that I'd like to display as one
field in a report where each daily activity doesn't include 24 line items,
but combines all 24 comments into one field displayed in the report in
just 1
row, not 24. I'm told I need to use VBA to accomplish this but am not
clear
how. Should the VBA code create a temp table with my query that then
counts
row by row to compare key fields, then concatentate that field and store
it
to a variable which I then write out to my report line by line? How do I
invoke that vba code (at what point, which event). Is there an mvp site
you
could refer me to with an example of what I'm trying to do? TIA