Trying to Average an Average

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In reports design view, Column B is an Average of specific values in Column
A. Column C has subtotals that are the average of the values in Column B.
When I preview the report, it keeps asking for the value of Column B, even
though the value is present, and the report returns no value for Column C. I
have tried to correct this error in the design query view but to no avail.

Column A is an expression
Column B is the average of the expression
Column C is the average of the average.

Any help would be much appreciated.
 
How about some actual:
-field names and data types
-Control Source expressions
-sections containing your controls
 
Column A is pulled from the design query and is located in the Detail portion
of the report = Pct_Off_Spread [Execution_Diff]/[Spread]
Column B is located in the Parent Footer of the report = Avg
([Pct_Off_Spread])
Column C is located in the Asset Class Footer of the report = Avg
([Avg_Pct_Off_Spread])

When I preview the report is ask for the criteria of Avg_Pct_Off_Spread,
even though it displays the values in column B but displays no values in
Column C.
 
You can't average (or sum) controls in a report. You can only reference
values from the report's record souce.

--
Duane Hookom
MS Access MVP


Joe said:
Column A is pulled from the design query and is located in the Detail
portion
of the report = Pct_Off_Spread [Execution_Diff]/[Spread]
Column B is located in the Parent Footer of the report = Avg
([Pct_Off_Spread])
Column C is located in the Asset Class Footer of the report = Avg
([Avg_Pct_Off_Spread])

When I preview the report is ask for the criteria of Avg_Pct_Off_Spread,
even though it displays the values in column B but displays no values in
Column C.

Duane Hookom said:
How about some actual:
-field names and data types
-Control Source expressions
-sections containing your controls
Click to expand...
Click to expand...
 
The report is avgeraging column B in the report. The control source is the
data in column A. I then have the report avg the data and show it in column
B. There is no record source for this average in the query, only the data in
column A, but the report still averages it in column B.

Duane Hookom said:
You can't average (or sum) controls in a report. You can only reference
values from the report's record souce.

--
Duane Hookom
MS Access MVP


Joe said:
Column A is pulled from the design query and is located in the Detail
portion
of the report = Pct_Off_Spread [Execution_Diff]/[Spread]
Column B is located in the Parent Footer of the report = Avg
([Pct_Off_Spread])
Column C is located in the Asset Class Footer of the report = Avg
([Avg_Pct_Off_Spread])

When I preview the report is ask for the criteria of Avg_Pct_Off_Spread,
even though it displays the values in column B but displays no values in
Column C.

Duane Hookom said:
How about some actual:
-field names and data types
-Control Source expressions
-sections containing your controls

--
Duane Hookom
MS Access MVP


In reports design view, Column B is an Average of specific values in
Column
A. Column C has subtotals that are the average of the values in Column
B.
When I preview the report, it keeps asking for the value of Column B,
even
though the value is present, and the report returns no value for Column
C.
I
have tried to correct this error in the design query view but to no
avail.

Column A is an expression
Column B is the average of the expression
Column C is the average of the average.

Any help would be much appreciated.
Click to expand...
Click to expand...
Click to expand...
 
Please replace the term "column" with either a field or text box.
As I stated, you can't average a text box. Maybe you should provide the
control source values for text box A and text box B.

--
Duane Hookom
MS Access MVP


Joe said:
The report is avgeraging column B in the report. The control source is
the
data in column A. I then have the report avg the data and show it in
column
B. There is no record source for this average in the query, only the data
in
column A, but the report still averages it in column B.

Duane Hookom said:
You can't average (or sum) controls in a report. You can only reference
values from the report's record souce.

--
Duane Hookom
MS Access MVP


Joe said:
Column A is pulled from the design query and is located in the Detail
portion
of the report = Pct_Off_Spread [Execution_Diff]/[Spread]
Column B is located in the Parent Footer of the report = Avg
([Pct_Off_Spread])
Column C is located in the Asset Class Footer of the report = Avg
([Avg_Pct_Off_Spread])

When I preview the report is ask for the criteria of
Avg_Pct_Off_Spread,
even though it displays the values in column B but displays no values
in
Column C.

:

How about some actual:
-field names and data types
-Control Source expressions
-sections containing your controls

--
Duane Hookom
MS Access MVP


In reports design view, Column B is an Average of specific values in
Column
A. Column C has subtotals that are the average of the values in
Column
B.
When I preview the report, it keeps asking for the value of Column
B,
even
though the value is present, and the report returns no value for
Column
C.
I
have tried to correct this error in the design query view but to no
avail.

Column A is an expression
Column B is the average of the expression
Column C is the average of the average.

Any help would be much appreciated.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top