Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2002
    Posts
    28

    Red face Unanswered: Calculated Field in Subform

    Hi,

    I have a calculated field in a subform (A x B) lets call it total1

    I want to find the total value of all the rows relating to total1.

    I have placed a count in the the footer of the form i.e =Count(total1)

    However all i get is #error when I try and run the form.

    Thanks in advance....

    Paul

  2. #2
    Join Date
    Feb 2002
    Posts
    2
    sounds like you're trying to sum the values in the column so you should probably use Sum instead of Count. Are you placing the formula in the subform footer or the main form footer? If it's in the subform then what you did should work. If it's in the main form you should try something like =sum(me!subform!total1). Alternatively, you could try placing your formula in the subform as you have it and refer to that text box from the main form like =me!subform!GrandTotal

Posting Permissions

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