MS Access Reports Calculating of a Calculated Field

[hhathome]

In my report I have a calculated DateDiff Field, I also have a
calculated count field. I'm trying to get a total of the DateDiff
field and dividing it by the count field and I'm having problems -- it
seems the calculated field is not storing the data for reuse, maybe --
does anyone have any suggestions?

Thanks

[Larry Linson]

<hh******@bellsouth.net> wrote in message
news:10**********************@k26g2000oda.googlegr oups.com...

In my report I have a calculated DateDiff Field, I also have a
calculated count field. I'm trying to get a total of the DateDiff
field and dividing it by the count field and I'm having problems -- it
seems the calculated field is not storing the data for reuse, maybe

Sometimes we have to know whether "field" is being loosely used as a term
for a "control" or if it really is referring to a "field" in the underlying
Record Source. You can't total a calculated Control in the Report. You
should be able to total a Calculated Field in the underlying Query, or use a
DSUM domain aggregate function.

We are really lacking enough detail to be of much help. Perhaps if you'd
clarify.

Larry Linson
Microsoft Access MVP

[Helen]

Thank you that did answer my question -- now I need to figure out how
to fix it. I have patients that are referred to our center and I'm
getting the days between referral and the day they are seen. I'm using
the DateDiff to determine this. I'm also getting a count of how many
patients have been referred and how many have been seen, which is also
working fine.

I'm trying to total the DateDiff numbers and divide by the count so I
can get a mean of all patients.

Hope this helps.

Helen