|
 |
access thread: Grand Total in Report
Message #1 by "Maha Arupputhan Pappan" <mahap@p...> on Wed, 19 Dec 2001 06:20:24
|
|
Hi all,
Good day.
I have problem calculating Grand Total in my Report. I have a calculated
field in the Detail section of my report. Let me call it TXTLUMPSUM. Now I
need to sum that field in my Group Footer section. I did this. I inserted
a field in the Footer section and called it TXTGRANDTOTAL and assigned its
data as =SUM(TXTLUMPSUM). When I preview report, it gives me a Dialog box
asking me to "Enter Parameter Value" for TXTGRANDTOTAL field.
How to over come this? Please guide.
Thanks,
Maha
Message #2 by "Richard Lobel" <richard@a...> on Tue, 18 Dec 2001 23:54:55 -0800
|
|
In your Group Footer section, use the exact same formula you use in the
detail section. In other words instead of trying to sum the calculated
results of TXTLUMPSUM, you will be using the base information. It will
sum for the group.
>I have problem calculating Grand Total in my Report. I have a
calculated
field in the Detail section of my report. Let me call it TXTLUMPSUM. Now
I
need to sum that field in my Group Footer section. I did this. I
inserted
a field in the Footer section and called it TXTGRANDTOTAL and assigned
its
data as =SUM(TXTLUMPSUM). When I preview report, it gives me a Dialog
box
asking me to "Enter Parameter Value" for TXTGRANDTOTAL field.<
Richard Lobel
Accessible Data
richard@a... <mailto:richard@a...>
Cell: (xxx) xxx-xxxx
Fax: (xxx) xxx-xxxx
Message #3 by "Maha Arupputhan Pappan" <mahap@p...> on Thu, 20 Dec 2001 07:50:43
|
|
> In your Group Footer section, use the exact same formula you use in the
> detail section. In other words instead of trying to sum the calculated
> results of TXTLUMPSUM, you will be using the base information. It will
> sum for the group.
>
> >I have problem calculating Grand Total in my Report. I have a
> calculated
> field in the Detail section of my report. Let me call it TXTLUMPSUM. Now
> I
> need to sum that field in my Group Footer section. I did this. I
> inserted
> a field in the Footer section and called it TXTGRANDTOTAL and assigned
> its
> data as =SUM(TXTLUMPSUM). When I preview report, it gives me a Dialog
> box
> asking me to "Enter Parameter Value" for TXTGRANDTOTAL field.<
>
> Richard Lobel
> Accessible Data
> richard@a... <mailto:richard@a...>
> Cell: (xxx) xxx-xxxx
> Fax: (xxx) xxx-xxxx
>
>
>
Hi Richard,
Thanks guy. I managed to get it done. However, I just wonder why is that
Access =SUM(TXTLUMPSUM) don't work. Afterall, it uses the same formula
thou.
Thanks Again.
Maha
|
|
|
View Cart
