Grand Total Question

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
 
B

Bruce Meneghin

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.
 
Z

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

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.

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
 
P

Peter Hibbs

Lisa

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

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

Good luck.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top