Results 1 to 9 of 9
  1. #1
    2 Star Lounger
    Join Date
    Aug 2001
    Posts
    116
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Calculated Control in a Continuous Subform (Access 2k/XP)

    I'm feeling especially woolly headed today <img src=/S/grin.gif border=0 alt=grin width=15 height=15>. I have a couple of calculated controls in a continuous subform. The problem is that when one control is calculated, its' value is replicated to each line in the subform. What am I missing here?

    TIA

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Calculated Control in a Continuous Subform (Access 2k/XP)

    Hi WoollyCats,

    It depends. If the control source of the calculated fields refers to fields in the record source of the subform, the value should change from record to record. What are you calculating?

  3. #3
    2 Star Lounger
    Join Date
    Aug 2001
    Posts
    116
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculated Control in a Continuous Subform (Access 2k/XP)

    My fields are as follows:
    "TestSubjects", "Replicates" and "My fields are as follows:
    "TestSubjects", "Replicates" and "My fields are as follows:
    "TestSubjects", "Replicates" and "My fields are as follows:
    "TestSubjects", "Replicates" and "%Contingency" are all stored in the table on which the subform is based.
    ContingencyNumber is calculated as: ("TestSubjects"* "Replicates") * "%Contingency"
    TotalNumber is calculated as: ("TestSubjects"* "Replicates") + ContingencyNumber

    I think there should be a pun here about shearing.

    TIAontingency" are all stored in the table on which the subform is based.
    ContingencyNumber is calculated as: ("TestSubjects"* "Replicates") * "Smiliesontingency"
    TotalNumber is calculated as: ("TestSubjects"* "Replicates") + ContingencyNumber

    I think there should be a pun here about shearing.

    TIA

  4. #4
    2 Star Lounger
    Join Date
    Aug 2001
    Posts
    116
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculated Control in a Continuous Subform (Access 2k/XP)

    Tres weird - I didn't double post that - and couldn't correct it either.

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Calculated Control in a Continuous Subform (Access 2k/XP)

    If I try to edit your post, the text multiplies itself even further - I think that "R e p l i c a t e s" is seen as a command by the HTML parser.

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Calculated Control in a Continuous Subform (Access 2k/XP)

    You shouldn't put quotes around the field names, but square brackets, e.g. [TestSubjects]. And the Control Source of a calculated control should start with =.

  7. #7
    2 Star Lounger
    Join Date
    Aug 2001
    Posts
    116
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculated Control in a Continuous Subform (Access 2k/XP)

    My bad, I am following those pointers in the DB - just typed them in differently in my question. Any other sources of problems you can find?
    TIA

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Calculated Control in a Continuous Subform (Access 2k/XP)

    No, so here is the question for if we have no idea: could you post a stripped down copy of the db?

  9. #9
    2 Star Lounger
    Join Date
    Aug 2001
    Posts
    116
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Calculated Control in a Continuous Subform (Access 2k/XP)

    I cried uncle and changed the controls to having a control source. Now, of course, there is no problem.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •