Calculate from Text Box on Report

[S Jackson]

I have created a text box on a report called TotalDays. Its control source
is:

=[ClosedDate]-[AssignDate]

I want to add a second text box to my report called AvgDays. I placed it in
the Report Footer and I want it to calculate
=Avg([TotalDays])

But when I run the report I get a parameter box asking me to insert the
TotalDays.
Can't get this to work and it seems it should be so simple. What am I
missing here?

S. Jackson

 

[Van T. Dinh]

Try

=Avg([ClosedDate] - [AssignDate])

 

[S. Jackson]

Doh! Yep - that worked! Thanks.

S. Jackson

Try

=Avg([ClosedDate] - [AssignDate])

--
HTH
Van T. Dinh
MVP (Access)

I have created a text box on a report called TotalDays. Its control source
is:

=[ClosedDate]-[AssignDate]

I want to add a second text box to my report called AvgDays. I placed

it

in
the Report Footer and I want it to calculate
=Avg([TotalDays])

But when I run the report I get a parameter box asking me to insert the
TotalDays.
Can't get this to work and it seems it should be so simple. What am I
missing here?

S. Jackson