Cannot get Grand Total to work

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

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~

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

[email protected] said:
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~

Bruce 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...
Click to expand...
 
Back
Top