Adding up subform text records

[Guest]

Based on these tables:
tblItems and tblItemAttributes, 1:M

and forms:
frmItems (Mainform) and subItemAttributes (Subform)

how would I go about adding up the records in a subform based on
tblItemAttributes? I want to be able to add a space between each attribute
as well.

Thanks

 

[Guest]

Bump.

For example, an item called "Sentence" has one or more words.

If my subform had three records:
We
the
people

How would I go about adding them up to equal "We the people"?

 

[John Vinson]

how would I go about adding up the records in a subform based on
tblItemAttributes? I want to be able to add a space between each attribute
as well.

Try the sample code at

http://www.mvps.org/access/modules/mdl0004.htm

John W. Vinson[MVP]