Adding an "Entire Goup" average and sum to a report...Help!

[Guest]

I have a crop production report that resembles the following:


2005 Corn Yields

Farm Field Acres Average Yield

Jims Home Farm 109.15 196.98
Jims New Farm 96.80 194.65
Combs 500 466.85 192.63
Reinking South 120.71 183.85
Fairmont Fairmont 20.76 146.55


Monday, January 30, 2006 Page 1 of 1

I would like to add a section under the last "Fairmont" farm and field,
which would say something like

"Entire Group" that would show the sum of the acres of all of the fields, as
well as the average of all of the fields together. Is this possible? I could
not find any way to do this as part of the query...

Thanks!
Bryan

 

[Guest]

In the footer insert a two textboxes with Acres as control source. Change
the property Running Sum to Over All.

In one edit the control source like --
=Sum([Acres])

In the other edit the control source like --
=Avg([Acres])
Set the format to as many places as you like.

 

[Guest]

Do I do that in report design view? All I could get was either an error, or
it would show the aces of the last record.

Sorry, I am really new to this.

In the footer insert a two textboxes with Acres as control source. Change
the property Running Sum to Over All.

In one edit the control source like --
=Sum([Acres])

In the other edit the control source like --
=Avg([Acres])
Set the format to as many places as you like.

I have a crop production report that resembles the following:


2005 Corn Yields

Farm Field Acres Average Yield

Jims Home Farm 109.15 196.98
Jims New Farm 96.80 194.65
Combs 500 466.85 192.63
Reinking South 120.71 183.85
Fairmont Fairmont 20.76 146.55


Monday, January 30, 2006 Page 1 of 1

I would like to add a section under the last "Fairmont" farm and field,
which would say something like

"Entire Group" that would show the sum of the acres of all of the fields, as
well as the average of all of the fields together. Is this possible? I could
not find any way to do this as part of the query...

Thanks!
Bryan

 

[Guest]

Did you put the text boxes in the Report Footer or Group Footer and not the
Page Footer?

Do I do that in report design view? All I could get was either an error, or
it would show the aces of the last record.

Sorry, I am really new to this.

In the footer insert a two textboxes with Acres as control source. Change
the property Running Sum to Over All.

In one edit the control source like --
=Sum([Acres])

In the other edit the control source like --
=Avg([Acres])
Set the format to as many places as you like.

I have a crop production report that resembles the following:


2005 Corn Yields

Farm Field Acres Average Yield

Jims Home Farm 109.15 196.98
Jims New Farm 96.80 194.65
Combs 500 466.85 192.63
Reinking South 120.71 183.85
Fairmont Fairmont 20.76 146.55


Monday, January 30, 2006 Page 1 of 1

I would like to add a section under the last "Fairmont" farm and field,
which would say something like

"Entire Group" that would show the sum of the acres of all of the fields, as
well as the average of all of the fields together. Is this possible? I could
not find any way to do this as part of the query...

Thanks!
Bryan