By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,679 Members | 2,331 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,679 IT Pros & Developers. It's quick & easy.

MS Access Reports Calculating of a Calculated Field

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a

<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

P: n/a
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.