All Information on one Line

[Jimmy]

Hi,

I have a one-to-many relationship going between two
tables. I am trying, on a report, to show the multiple
records for a specific record all on one line.

ie: Main Table "Family Name"
sub-table "Father
Mother
Sister
Brother"

Would like to be able to printout like:

Family Name: Father, Mother, Sister, Brother

Appreciate any help.
Jimmy

 

[Niklas Östergren]

Hi!

Try this in the row source of the textbox:

= [YourTableName.Father] & ", " & [YourTableName.Mother] & ", " &
[YourTableName.Sister] & ", " & [YourTableName.Brother]

// Niklas

 

[Duane Hookom]

Check out the generic concatenate function at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. There
are demo forms that display how it can be used.