Report design with Total Amounts

[Ayo]

Is this possible?
I created a report but some of the results span more than a page, or two.
It has a coulmn in it that has inv. Amounts. I want to be able to put a
Total Invoice Amount at the bottom of each page, for the invoices on that
page. And at the end of the report, I want to have a Grand Total Amount and
the Total Invoice Amount. How can I do this?
Any help will be greatly appreciated. Thanks
Ayo

 

[boblarson]

Make sure the page and report footers are displayed and then in each have a
text box with the control source as

=Sum([YourFieldNameHere])

in each. It should display the value for each page in the page footer and
the total value in the report footer.
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
__________________________________
If my post was helpful to you, please rate the post.

 

[Ayo]

Thanks

Make sure the page and report footers are displayed and then in each have a
text box with the control source as

=Sum([YourFieldNameHere])

in each. It should display the value for each page in the page footer and
the total value in the report footer.
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
__________________________________
If my post was helpful to you, please rate the post.

Is this possible?
I created a report but some of the results span more than a page, or two.
It has a coulmn in it that has inv. Amounts. I want to be able to put a
Total Invoice Amount at the bottom of each page, for the invoices on that
page. And at the end of the report, I want to have a Grand Total Amount and
the Total Invoice Amount. How can I do this?
Any help will be greatly appreciated. Thanks
Ayo

 

[Ayo]

The page =Sum([Invoice Amount]) is showing an #Error message. And on the last
page, the page =Sum([Invoice Amount]) is coming after the report
=Sum([Invoice Amount]). Any ideas?

Make sure the page and report footers are displayed and then in each have a
text box with the control source as

=Sum([YourFieldNameHere])

in each. It should display the value for each page in the page footer and
the total value in the report footer.
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
__________________________________
If my post was helpful to you, please rate the post.

Is this possible?
I created a report but some of the results span more than a page, or two.
It has a coulmn in it that has inv. Amounts. I want to be able to put a
Total Invoice Amount at the bottom of each page, for the invoices on that
page. And at the end of the report, I want to have a Grand Total Amount and
the Total Invoice Amount. How can I do this?
Any help will be greatly appreciated. Thanks
Ayo

 

[boblarson]

The error message may be that you have nulls, or the name of the text box is
the same name as Invoice Amount. Make sure the name isn't the same as the
field and make sure that it doesn't have nulls by changing it to

=Sum(Nz([Invoice Amount],0))

As for the last page, the page footer does come after the report footer, so
you can try doing this (it's a bit complex) but you can set it so that if the
last page is showing, you can make the page footer be invisible and put a
text box which shows in the report footer that references the page footer
text box:
=[YourPageFooterTextBoxNameHere]


--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
__________________________________
If my post was helpful to you, please rate the post.

Thanks

Make sure the page and report footers are displayed and then in each have a
text box with the control source as

=Sum([YourFieldNameHere])

in each. It should display the value for each page in the page footer and
the total value in the report footer.
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
__________________________________
If my post was helpful to you, please rate the post.

Is this possible?
I created a report but some of the results span more than a page, or two.
It has a coulmn in it that has inv. Amounts. I want to be able to put a
Total Invoice Amount at the bottom of each page, for the invoices on that
page. And at the end of the report, I want to have a Grand Total Amount and
the Total Invoice Amount. How can I do this?
Any help will be greatly appreciated. Thanks
Ayo

 

[Ayo]

Thanks again.

The error message may be that you have nulls, or the name of the text box is
the same name as Invoice Amount. Make sure the name isn't the same as the
field and make sure that it doesn't have nulls by changing it to

=Sum(Nz([Invoice Amount],0))

As for the last page, the page footer does come after the report footer, so
you can try doing this (it's a bit complex) but you can set it so that if the
last page is showing, you can make the page footer be invisible and put a
text box which shows in the report footer that references the page footer
text box:
=[YourPageFooterTextBoxNameHere]


--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
__________________________________
If my post was helpful to you, please rate the post.

Thanks

Make sure the page and report footers are displayed and then in each have a
text box with the control source as

=Sum([YourFieldNameHere])

in each. It should display the value for each page in the page footer and
the total value in the report footer.
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
__________________________________
If my post was helpful to you, please rate the post.


:

Is this possible?
I created a report but some of the results span more than a page, or two.
It has a coulmn in it that has inv. Amounts. I want to be able to put a
Total Invoice Amount at the bottom of each page, for the invoices on that
page. And at the end of the report, I want to have a Grand Total Amount and
the Total Invoice Amount. How can I do this?
Any help will be greatly appreciated. Thanks
Ayo