Grand Total Question

  • Thread starter Thread starter peashoe
  • Start date Start date
P

peashoe

I can't get my grand total to work?

txtTotal control
source=[Price]+[PlusPrice]+([ExtraRoomPrice]*[ExtendedDays]) which
gives me what I need per row.

My grand total is named txtBalanceDue and Control
source=SUM([txtTotal]) what am I doing wrong? Also, txtTotal is in the
detail section and the txtBalanceDue is in the page footer.

Thanks in advance
Lisa
 
I think the txtTotal should be in a Group footer or Report footer, not a page
footer. If there is some grouping like Client or InvoiceNum then it would go
in the Group footer, if it is a Grand total, then put it in a Report Footer.
 
Right, Access doesn't automatically do per-page totals, so a SUM in the page
footer won't work correctly.

--
Zac Woodall | Program Manager | Microsoft Access

Bruce Meneghin said:
I think the txtTotal should be in a Group footer or Report footer, not a
page
footer. If there is some grouping like Client or InvoiceNum then it would
go
in the Group footer, if it is a Grand total, then put it in a Report
Footer.

[email protected] said:
I can't get my grand total to work?

txtTotal control
source=[Price]+[PlusPrice]+([ExtraRoomPrice]*[ExtendedDays]) which
gives me what I need per row.

My grand total is named txtBalanceDue and Control
source=SUM([txtTotal]) what am I doing wrong? Also, txtTotal is in the
detail section and the txtBalanceDue is in the page footer.

Thanks in advance
Lisa
Click to expand...
Click to expand...
 
Lisa

In the Control Source property of your txtBalanceDue control try entering :-

= Sum([Price]+[PlusPrice]+([ExtraRoomPrice]*[ExtendedDays]))

Good luck.
 
Back
Top