REPORT PAGESUM NOT WORKING IN ACCESS 2007

[h2mhd]

HI

i have developped an application with office 2003, and in some of my report i have a pagesum total that show on each end of a page the subtotal of the current page.

since i have migrate in access 2007 the pagesum is no longer working... is there a way to work around this issue??

thanks a lot for your help

 

[lameid]

Any reason your not just using the pages property in your control source....

Typically something like the below in a page footer.

= [Page] & " " & [Pages]

 

[h2mhd]

thanks for your response

but my problem is if the report invoice have more than 1 page i want to show a sub total of the amount of that page.

so page 1:
12.35$
15.35$
19.56$
-----
47.26$ sub total

pages 2 and so on!

earlier i have declared a variable pagesum that was looping on the content of the invoice and add the amount but since i updated to access 2007 its no longer working

it shows me name?

can you help me fin a way to solve this issue?

thanks a lot

 

[lameid]

All the query aggregate functions work in reports and group according to the section...

So if in the page footer you have a control with a control source that sums your column, it will show the total for that page.

=sum([amount])

If you want to use that value somewhere else, name the control, set it's visible property to false, and use the control name to get at your value where you need it.

 

[dhookom]

You can't use aggregate functions like Sum(), Max(), Count() etc in PAGE sections like you can in Report and Group sections.

Apparently h2mhd is using code which I wish he/she would share so we could provide some assistance. We can't fix what we can't see.

Duane
Hook'D on Access
MS Access MVP

 

[lameid]

I think I keep forgetting you can't do that in page footers... That is I feel Deja Vu. Maybe this time it will stick.

That being the case we definitely need the code.