Form Total Help

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

I have a form I use for bank deposits and I need to show the total for the
deposit for that day. If I put the text box in the form footer it totals up
all the deposits in the table. If I put it in the page footer, neither the
label or text box shows up even though they are both set to visible. Any
ideas on what's happening?
Thanks for any help/suggestions.

Jim
 
Jim said:
I have a form I use for bank deposits and I need to show the total for the
deposit for that day. If I put the text box in the form footer it totals up
all the deposits in the table. If I put it in the page footer, neither the
label or text box shows up even though they are both set to visible. Any
ideas on what's happening?
Click to expand...


The aggregate functions do not operate in page sections.
They can only operate on the entire form (or subform). For
report's they also operate on groups in any group header or
footer section.
 
Back
Top