Use DSum ?

[chickalina]

I wanted to know if DSum could be used for the following:

=Sum ([text174], [BenefitType],[ETR Only])

Which I understand to mean...

Sum everything in Text174, where Benefit Type is ETR Only. Yes??
Text 174 is in the details section, and Benefit Type is not a Header or
Footer, but it is a field in the details section.

This doesn't work.

Thanks!

 

[John Spencer]

Probably you want something like the following. Replace
SomeFieldInRecordSource with the Control source for text174 - probably a
field name in your table or query for the report.

=Sum (IIf([BenefitType] ="ETR Only", [SomeFieldInRecordSource], Null))


--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..