469,288 Members | 2,320 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,288 developers. It's quick & easy.

How to display Page total and Grand total in MS-Access

How shall I count (Sum)a running total of each page and display and finally show the grand total and display the same in the last page in MS-Access Report?

Please help me.

Arunansu Dasgupta
Mar 20 '11 #1
7 8130
32,173 Expert Mod 16PB
Totals in a Page Footer show Page totals and totals in a Report Footer show Report totals.
Mar 20 '11 #2
Ok, Please tell me the name of function and show the trick (i.e. how and where to wite the sysntax) that I need to use to solve my problem.

Arunansu Dasgupta
Mar 21 '11 #3
32,173 Expert Mod 16PB
What problem. You asked a question. I've answered it.

If you have another problem then you need to ask it. Clearly. Include any relevant information obviously.
Mar 21 '11 #4
I want to compute the cumulative sum of the values of a particular field at the end of every page and finally the grand total sum at the end of the last page.
Mar 21 '11 #5
32,173 Expert Mod 16PB
... and the relevant information is where in that post?
Mar 21 '11 #6
Please tell me what function to use that will compute the cumulative sum of all the values of a particular field page wise and show the grand total of all the values of that field at the end of the last page in MS ACCESS report.
Please give the solution with syntax.
Mar 23 '11 #7
32,173 Expert Mod 16PB
Did you not see the PM about the deleted post? In the reason it said "Provide names of objects at least." That said, it seems clear you have at least tried to make progress so I'll do what I can for you without the names.

I'll lay out for you what you should have included in your post so that you can more easily understand the answer. Obviously it works better if we work with your information, as that is easier to understand, but I'll do my best to make it clear anyway. I have to make assumptions though so don't be too surprised if I get some wrong.

Working then, on the assumption that you have a report designed with Detail, Page Footer and Report Footer sections, we could have TextBox controls in each section named respectively A, PageTotA and RptTotA.

A simply contains the values that are found in each record.
PageTotA contains the formula =Sum(A).
RptTotA contains the formula =Sum(A).

Notice that the formulas for both PageTotA and RptTotA are identical. Determining which values to sum is down to the sections they're each contained in.
Mar 23 '11 #8

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

4 posts views Thread by lyndsey | last post: by
3 posts views Thread by kkshansid | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.