Grand Total Question

[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

 

[Guest]

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.

 

[Zac Woodall [MSFT]]

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

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.

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

 

[Guest]

Lisa

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

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

Good luck.