Jeff L said:=Avg([YourFieldName])
I have an expression in a query counting the number of days between 2 dates.
On my report I would like to average the number of days counted in the field.
I cannot figure out the expression to use to average these numbers. Can
anyone offer any suggestions?
Ronnie said:That is what I have. The field name is "Expr1"
--
Ronnie
Jeff L said:=Avg([YourFieldName])
I have an expression in a query counting the number of days between 2
dates.
On my report I would like to average the number of days counted in the
field.
I cannot figure out the expression to use to average these numbers.
Can
anyone offer any suggestions?
Duane Hookom said:You should have provided your attempted control source and control name. It
also makes a difference what section of the report your text box is located.
You should have also included the results displayed in your report.
Make sure the name of the control is not the name of a field. The text box
should not be placed in the Page Header or Page Footer sections.
--
Duane Hookom
MS Access MVP
Ronnie said:That is what I have. The field name is "Expr1"
--
Ronnie
Jeff L said:=Avg([YourFieldName])
Ronnie wrote:
I have an expression in a query counting the number of days between 2
dates.
On my report I would like to average the number of days counted in the
field.
I cannot figure out the expression to use to average these numbers.
Can
anyone offer any suggestions?
Ronnie said:The text box was located in the footer, so moving this did make the
expression work, however, now it prints this average after each record
instead of once at the bottom!
--
Ronnie
Duane Hookom said:You should have provided your attempted control source and control name.
It
also makes a difference what section of the report your text box is
located.
You should have also included the results displayed in your report.
Make sure the name of the control is not the name of a field. The text
box
should not be placed in the Page Header or Page Footer sections.
--
Duane Hookom
MS Access MVP
Ronnie said:That is what I have. The field name is "Expr1"
--
Ronnie
:
=Avg([YourFieldName])
Ronnie wrote:
I have an expression in a query counting the number of days between
2
dates.
On my report I would like to average the number of days counted in
the
field.
I cannot figure out the expression to use to average these numbers.
Can
anyone offer any suggestions?
Duane Hookom said:Place the text box in the Report Footer section.
--
Duane Hookom
MS Access MVP
Ronnie said:The text box was located in the footer, so moving this did make the
expression work, however, now it prints this average after each record
instead of once at the bottom!
--
Ronnie
Duane Hookom said:You should have provided your attempted control source and control name.
It
also makes a difference what section of the report your text box is
located.
You should have also included the results displayed in your report.
Make sure the name of the control is not the name of a field. The text
box
should not be placed in the Page Header or Page Footer sections.
--
Duane Hookom
MS Access MVP
That is what I have. The field name is "Expr1"
--
Ronnie
:
=Avg([YourFieldName])
Ronnie wrote:
I have an expression in a query counting the number of days between
2
dates.
On my report I would like to average the number of days counted in
the
field.
I cannot figure out the expression to use to average these numbers.
Can
anyone offer any suggestions?
Ronnie said:Thanks! This worked. However, now the expression has about 8 decimal
places. I've tried setting the properties for "0", "Auto", "1", and "2".
It
still shows about 8 places. Any suggestions?
--
Ronnie
Duane Hookom said:Place the text box in the Report Footer section.
--
Duane Hookom
MS Access MVP
Ronnie said:The text box was located in the footer, so moving this did make the
expression work, however, now it prints this average after each record
instead of once at the bottom!
--
Ronnie
:
You should have provided your attempted control source and control
name.
It
also makes a difference what section of the report your text box is
located.
You should have also included the results displayed in your report.
Make sure the name of the control is not the name of a field. The text
box
should not be placed in the Page Header or Page Footer sections.
--
Duane Hookom
MS Access MVP
That is what I have. The field name is "Expr1"
--
Ronnie
:
=Avg([YourFieldName])
Ronnie wrote:
I have an expression in a query counting the number of days
between
2
dates.
On my report I would like to average the number of days counted
in
the
field.
I cannot figure out the expression to use to average these
numbers.
Can
anyone offer any suggestions?
Duane Hookom said:You usually have to set the Format to something like "Standard" and then set
the decimal placed.
--
Duane Hookom
MS Access MVP
Ronnie said:Thanks! This worked. However, now the expression has about 8 decimal
places. I've tried setting the properties for "0", "Auto", "1", and "2".
It
still shows about 8 places. Any suggestions?
--
Ronnie
Duane Hookom said:Place the text box in the Report Footer section.
--
Duane Hookom
MS Access MVP
The text box was located in the footer, so moving this did make the
expression work, however, now it prints this average after each record
instead of once at the bottom!
--
Ronnie
:
You should have provided your attempted control source and control
name.
It
also makes a difference what section of the report your text box is
located.
You should have also included the results displayed in your report.
Make sure the name of the control is not the name of a field. The text
box
should not be placed in the Page Header or Page Footer sections.
--
Duane Hookom
MS Access MVP
That is what I have. The field name is "Expr1"
--
Ronnie
:
=Avg([YourFieldName])
Ronnie wrote:
I have an expression in a query counting the number of days
between
2
dates.
On my report I would like to average the number of days counted
in
the
field.
I cannot figure out the expression to use to average these
numbers.
Can
anyone offer any suggestions?
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.