By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,915 Members | 1,335 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,915 IT Pros & Developers. It's quick & easy.

Calculated field in report

P: n/a
I have a report based on query that has output fields:
Category1
Category2
Category3
SumOfAmount
The report has a group band on category 1. Within this group I would like to
sum the values of SumOfAmount that are in this group.
How do I make a calculated field that does this?
Thanks in advance,
john
Sep 23 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Sat, 23 Sep 2006 20:30:11 +0200, "john" <jo**@test.comwrote:

In the footer of the Category1 group, create a textbox and set the
controlsource to:
=Sum([SumOfAmount])

-Tom.

>I have a report based on query that has output fields:
Category1
Category2
Category3
SumOfAmount
The report has a group band on category 1. Within this group I would like to
sum the values of SumOfAmount that are in this group.
How do I make a calculated field that does this?
Thanks in advance,
john
Sep 23 '06 #2

P: n/a
Thanks.
john

"Tom van Stiphout" <no*************@cox.netschreef in bericht
news:1t********************************@4ax.com...
On Sat, 23 Sep 2006 20:30:11 +0200, "john" <jo**@test.comwrote:

In the footer of the Category1 group, create a textbox and set the
controlsource to:
=Sum([SumOfAmount])

-Tom.

>>I have a report based on query that has output fields:
Category1
Category2
Category3
SumOfAmount
The report has a group band on category 1. Within this group I would like
to
sum the values of SumOfAmount that are in this group.
How do I make a calculated field that does this?
Thanks in advance,
john

Sep 24 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.