INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

REPORT PAGESUM NOT WORKING IN ACCESS 2007

REPORT PAGESUM NOT WORKING IN ACCESS 2007

(OP)
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

RE: REPORT PAGESUM NOT WORKING IN ACCESS 2007

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

Typically something like the below in a page footer.

CODE

= [Page] & " " & [Pages] 

RE: REPORT PAGESUM NOT WORKING IN ACCESS 2007

(OP)
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

RE: REPORT PAGESUM NOT WORKING IN ACCESS 2007

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.

CODE

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

RE: REPORT PAGESUM NOT WORKING IN ACCESS 2007

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

RE: REPORT PAGESUM NOT WORKING IN ACCESS 2007

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. blush surprise

That being the case we definitely need the code.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close