If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Help again from Ken Snell (Query) | Randy | Running & Setting Up Queries | 22 | August 29th, 2005 08:15 PM |
Multiple Options Group | Patty Stoddard | Using Forms | 19 | August 4th, 2005 02:30 PM |
pass a calculated form field to a subform field? | Brook | Using Forms | 22 | April 28th, 2005 04:56 PM |
Ideas On Producing Envelopes & Labels For Data | RNUSZ@OKDPS | Setting Up & Running Reports | 0 | April 28th, 2005 03:22 PM |
Must # of fields in the 2 tables in an Append Query be equal? | CreativeImages | Running & Setting Up Queries | 3 | October 1st, 2004 05:16 PM |