Cannot get Grand Total to work

[peashoe]

Bruce,
I tried that and the total is $0.00 - Do I need to add something to the
properties maybe? I tried changing the running sum field but that
doesn't work. Also, now a Total pop-up box comes up when I run the
report

~L~

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

 

[Damian S]

Hi Linda,

The running sum functionality in Access is flaky at best... In theory what
you have tried *should* work, but it doesn't. Try
=sum([Price]+[PlusPrice]+([ExtraRoomPrice]*[ExtendedDays]))

With Running Sum set to Over Group.

Damian.

Bruce,
I tried that and the total is $0.00 - Do I need to add something to the
properties maybe? I tried changing the running sum field but that
doesn't work. Also, now a Total pop-up box comes up when I run the
report

~L~

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