Welcome to SPN

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

Sign Up Now!

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]
     

Share This Page