G
Guest
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
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