Sum Function on a form

  • Thread starter Thread starter Eric
  • Start date Start date
E

Eric

Is there a way to make a textbox on a form display the
total of other textboxes on a form without placing
the "Total" textbox in the footer? I need it to be
located in the body of the form because the form is
printed out. I've tried a hundred different codes in the
code builder but none of my Excel coding seems to work in
Access.

I've tried:
1.) Me.GrandTotal = Sum([Me.TotalCost1]+[Me.TotalCost2])

2.) Me.GrandTotal.Value = Sum([Me.TotalCost1.Value]+etc...

I've tried it in any number of combinations:
1.) With the "Sum" Function (Access does not seem to
recognize "Sum")

2.) Without the "Sum" Function (There, I get Both of
my "TotalCosts" Side By Side in the Grand Total Box)

3.) Without the "Me" Part in the identifier. (That
doesn't work at all)

I'm just about to lose my marbles on this one. I know
that placing the "GrandTotal" box in another part of the
form makes this work much easier, but I need to find a
way to make it happen in the Detail section of the form.
Any help on this would really be appreciated!!
 
Go ahead and place the GrandTotal in the footer. Then include another text
box in the detail section that is =[GrandTotal]. Make the footer's visible
property No so it won't appear.

Kelvin
 
Back
Top