470,602 Members | 1,472 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,602 developers. It's quick & easy.

MS Access Reports Calculating of a Calculated Field

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

Nov 13 '05 #1
2 5164

<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
Nov 13 '05 #2
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

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Michael Bulatovich | last post: by
1 post views Thread by Frank Murren | last post: by
2 posts views Thread by Matthew Kramer | last post: by
4 posts views Thread by alexandre.brisebois | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.