Subform not displaying footer total

Attached document shows how I've defined a simple subform with a total in the footer.  I've inserted the subform into a page, but cannot get the grand total to display.  See attached screenshots.  This should be so simple!
Who is Participating?
Jeffrey CoachmanMIS LiasonCommented:
You cannot sum a textbox:   =Sumt(txtTotalCost)
You can, however, sum the "Field":  =Sum(TotalCost)
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
If your subform is in Datasheet view (or a query - which will be displayed as a datasheet), then the Header and Footer do not show. For these to show, you need to use a Continuous  Form view.

kerikeriAuthor Commented:
Thanks Experts!  re mx's comment, the subform was a Continuous form already.  I just modified the Grand Total field from Sum(txtTotalCost), to Sum(TotalCost) and works perfectly.  Will remember this for future forms.
Jeffrey CoachmanMIS LiasonCommented:
To be sure, I almost missed you mistake too...

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.