average values

  • Thread starter Thread starter alex
  • Start date Start date
A

alex

i have a report based from a query that calculates the
turnaround time for a process. how can i get my report to
display the average of all these totals?
 
alex said:
i have a report based from a query that calculates the
turnaround time for a process. how can i get my report to
display the average of all these totals?
Click to expand...

Does a text box with an expression like =Avg(thefield) in
the appropriate group or report footer do what you want?

If not, tell us more about the report so we can figure out
what you need.
 
i've tried doing that, but when i try to leave design
view, i get a box asking me to enter manual parameters,
instead of calculating from the figures that are already
there. i know my previous post was kind of sparse, what
other info do you need?
 
alex said:
i've tried doing that, but when i try to leave design
view, i get a box asking me to enter manual parameters,
instead of calculating from the figures that are already
there. i know my previous post was kind of sparse, what
other info do you need?
Click to expand...

What is the name of the field that you want to average?

What are the names of the pertinate controls in the report?
(Don't confuse a field in the report's record source
table/query with a control (text box, etc) on the report.)

What was the exact expression that you used?

What were you prompted for?
--
Marsh
MVP [MS Access]


 
What is the name of the field that you want to average?
What are the names of the pertinate controls in the report?
(Don't confuse a field in the report's record source
table/query with a control (text box, etc) on the report.)
Click to expand...

i'm a little confused by these two (i'm not a particularly
advanced user), so i'm going to answer what i think you're
asking:
my report is based on a query with the following fields:
Customer Name
App Number
Administrator
Date/time Administrator
Date/time Analyst
AdminTurnaround Hours

To my understanding, there are (outside of the average I
am trying to do) no controls in the report, I am merely
displaying the information from the query.
What was the exact expression that you used?
Click to expand...

I placed a text box in the Page Footer labelled Average:,
and the Expression was =Avg([AdminTurnaround Hours]).
Now, instead of prompting me for parameters, it is showing
the Average field on the report, but returning #Error
instead of a value.
What were you prompted for?
Click to expand...
I was prompted to enter a parameter, and when I went to
the report whatever i had entered in the parameter box was
what displayed on the report. I just tried it again,
however, and got the response detailed above.
--
Marsh
MVP [MS Access]


report
to
Click to expand...

.
Click to expand...
 
alex said:
What is the name of the field that you want to average?
Click to expand...
What are the names of the pertinate controls in the report?
(Don't confuse a field in the report's record source
table/query with a control (text box, etc) on the report.)
Click to expand...

i'm a little confused by these two (i'm not a particularly
advanced user), so i'm going to answer what i think you're
asking:
my report is based on a query with the following fields:
Customer Name
App Number
Administrator
Date/time Administrator
Date/time Analyst
AdminTurnaround Hours

To my understanding, there are (outside of the average I
am trying to do) no controls in the report, I am merely
displaying the information from the query.
What was the exact expression that you used?
Click to expand...

I placed a text box in the Page Footer labelled Average:,
and the Expression was =Avg([AdminTurnaround Hours]).
Now, instead of prompting me for parameters, it is showing
the Average field on the report, but returning #Error
instead of a value.
Click to expand...

OK, that's a problem. The aggregate functions (Count, Sum,
Avg, etc) can not work in a page footer (they can't figure
out the range they should operate on).

Move (drag) the text box to the report footer section.

I was prompted to enter a parameter, and when I went to
the report whatever i had entered in the parameter box was
what displayed on the report. I just tried it again,
however, and got the response detailed above.
Click to expand...

The above may solve the problem so this question may be
moot, but what I wanted to know here was the **exact**
string in the prompt. It should have said something like:

AdminTurnaround Hours
--
Marsh
MVP [MS Access]

 
Back
Top