Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

Adding up subform text records

Discussion in 'Information Technology' started by Ricter, Jul 28, 2006.

  1. Ricter

    Ricter
    Expand Collapse
    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
     
  2. Ricter

    Ricter
    Expand Collapse
    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"?


    "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. John Vinson

    John Vinson
    Expand Collapse
    Guest

    On Wed, 19 Jul 2006 14:36:02 -0700, Ricter
    <Ricter@discussions.microsoft.com> wrote:

    >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]
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page