using field in detail for domain aggregate function

  • Thread starter Thread starter Craig
  • Start date Start date
C

Craig

I am trying to use information in a field in the detail
section of a report to calculate a davg in another field
of the detail section. Getting no result and no error.
Any ideas?

=Davg("[ipp]","incentive","[calcgrp]=reports!report1!
[calcgroup]")

Thanks, all.
 
Craig said:
I am trying to use information in a field in the detail
section of a report to calculate a davg in another field
of the detail section. Getting no result and no error.
Any ideas?

=Davg("[ipp]","incentive","[calcgrp]=reports!report1!
[calcgroup]")
Click to expand...


You don't want to include the reference inside the quotes,
you want to use the value in the reference:

=Davg("[ipp]", "incentive", "[calcgrp]=" &
reports!report1![calcgroup])
 
You must log in or register to reply here.

Ask a Question

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.

Ask a Question

Similar Threads

Pass report's recordsource value to DAvg function call 3
Daily Average by quarter 9
Summary Functions taking too long and Dynamic Chang of Detail Field Backgrounds 2
Group last line of details and report footer 0
Custom function in detail section 2
Control detail section height size in Ac2007 2
Memo in Report causing blank pages/other issues 2
Using "Sum" to add values from records in detail section 8

Back
Top