Adding up subform text records

#1 (**permalink**) 28-Jul-2006, 08:38 AM

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/13570-adding-up-subform-text-records.html
as well.

Thanks

*

#2 (**permalink**) 28-Jul-2006, 08:38 AM

Bump.

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13570
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"?
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13570

"Ricter" wrote:

> 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

#3 (**permalink**) 28-Jul-2006, 08:38 AM

On Wed, 19 Jul 2006 14:36:02 -0700, Ricter
wrote:

>how would I go about adding up the records in a subform based on
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13570
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13570
>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]