Text string

[rkawasak]

Here is my problem:
I have two tables - one with my main records and the other with associated information.
For each main record I can have several associated entries (text). For data entry I have set up a main form where the main record gets entered, and a subform within my main form, where I enter the associated entries.
When generating reports, I end up with each main record repeated for each one of the associated entries.
I would like to have the associated entries combined into one text string, and each main entry showing up only once on my report.
To illustrate:

Now:
Main record 1 - text1
Main record 1 - text2
Main record 1 - text3

Desired result:
Main record 1 - text1, text2, text3

Any assistance will be greatly appreciated.
Thanks in advance!

 

[Surjer]

If you are using the report wizard you can add grouping so that your main records are only displayed once....

If that doesn't work post again and we'll go from there...

 

[Nova_C]

Another thing you can try is a statement like this :
"[mainrecord1] & " : " & [text1] & ", " & [text2] & ", " & [text3]