Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2003

    Angry Unanswered: Calculating a total from subform

    Hey there.

    I'm trying to calculate a total (in this case of a quantity of spares) from a subform. The total quantity which will in fact be a running total resides on the main form. I've been trying for days and I think I'm developing a nervous tick......

    Any help would be massively appreciated!!!



  2. #2
    Join Date
    Sep 2001
    If it is that you have a column on a subform for which you want to total and display the total on the main form you can try the following:

    Create an unbound field on the subform. In the control source for this field type =Sum(fieldname) (This holds the total amount). Then on the main form create another unbound field and in the record source type
    =[subformname].Form!fieldname (fieldname here being the name of the field on the subform that holds the total).

    If this is not what you want, probably you can give a little more details.

    Good Luck!

  3. #3
    Join Date
    Jun 2003
    Thanks VERY VERY much... I can now go out and enjoy myself this evening :-)

    That worked a treat.


Posting Permissions

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