Hi all,
Is it possible to display a sum of values on one page of a access report only?
At current I am using this equasion =Sum([Actual_Stall_Price]) and I am placing the text box with this control on the page fotter but no joy.
If i place it in the detail section of the report i get the total for all pages within the report. As this report creates many pages, each being sent to a different client I only want to send the charges on that page of the report and not the total(if that makes sense)
I have looked at the Running Sum option but this does not help either.
Thanks in advance for all suggestions and advice given.
Is there a way I do this?
Is it possible to display a sum of values on one page of a access report only?
At current I am using this equasion =Sum([Actual_Stall_Price]) and I am placing the text box with this control on the page fotter but no joy.
If i place it in the detail section of the report i get the total for all pages within the report. As this report creates many pages, each being sent to a different client I only want to send the charges on that page of the report and not the total(if that makes sense)
I have looked at the Running Sum option but this does not help either.
Thanks in advance for all suggestions and advice given.
Is there a way I do this?