locked
Subform Totals RRS feed

  • Question

  • Hello,

    I know I've done this in the past; however hung up on a problem.  My subform footer results continue to #ERROR.  Can you help with what I'm missing?  Because the TotalCstOOC is a calculated field, I am using the =sum([UnitCstOOC]+[MtlCstOOC]+[LbrCstOOC]+[equipOOC]) in the Footer calculation vs the TotalCstOOC field name.


    Thanks PU_RJF

    Friday, April 10, 2020 5:28 PM

Answers

  • I completely missed the fact that you are attempting to Sum totals from a main form onto a subform. Try:

    =Forms![sfrmOOCDetail]![UnitCstOOC]+Forms![sfrmOOCDetail]![MtlCstOOC]+ etc.

    • Marked as answer by PU_RJF Monday, May 18, 2020 12:43 PM
    Friday, April 10, 2020 8:18 PM

All replies

  • I noticed your UnitCstOOC field is not Currency so you are summing different number formats. You also have two textboxes with the same name of Text30. 
    Friday, April 10, 2020 5:39 PM
  • Hello,

    Thank you for the response. I have addressed but still receive same #ERROR


    Thanks PU_RJF

    Friday, April 10, 2020 5:49 PM
  • Try:

    =Sum([UnitCstOOC]) + Sum([MtlcstOOc]) + Sum() etc. etc.

    Friday, April 10, 2020 6:04 PM
  • I completely missed the fact that you are attempting to Sum totals from a main form onto a subform. Try:

    =Forms![sfrmOOCDetail]![UnitCstOOC]+Forms![sfrmOOCDetail]![MtlCstOOC]+ etc.

    • Marked as answer by PU_RJF Monday, May 18, 2020 12:43 PM
    Friday, April 10, 2020 8:18 PM